Some of the SQL server General concepts?

-
1.How to get all tables in a database particular database ?

use Finance
Go
select * from INFORMATION_SCHEMA.TABLES

2.How to get all Column in a database particular database ?
use Finance
Go
select * from INFORMATION_SCHEMA.columns

3.How to get all views in a database particular database ?
use Finance
Go
select * from INFORMATION_SCHEMA.VIEW_TABLE_USAGE

4.list all the databases in SQL server  ?
exec sp_MSforeachdb '  
use [?]
select DB_NAME()'

5.How to get  SQL Server edition ?
select @@VERSION

6.How to Rename a Table in SQL Server ?

Using system store procedure Sp_Rename


Use Test
Go

Exec sp_rename  Old_table name , New_tablename

using Sp_Rename  to rename all the sql server Objects 
like 1. Table name
      2. Store Procedure
      3. View name
      4. User defined function name   Etc.

Comments

Post a Comment

Popular Posts

Group by and Having ,Order by

-
Image
Group By -  In SQL Server we have got lot of aggregate functions. Examples 1. Count() 2. Sum() 3. avg() 4. Min() 5. Max() Group by  clause is used to group a selected set of rows into a set of summary rows by the values of one or more columns or expressions. It is always used in conjunction with one or more aggregate functions. I want an sql query, which gives total salaries paid by City. The output should be as shown below. Query for retrieving total salaries by city : We are applying SUM() aggregate function on Salary column, and grouping by city column. This effectively  adds, all salaries of employees with in the same city. Select  City,  SUM (Salary)  as  TotalSalary  from  tblEmployee Group by  City Note:  If you omit, the group by clause and try to execute the query, you get an error -  Column 'tblEmployee.City' is invalid in the select list  because it is not ...
Read more