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.