SQL alter column name and table name

CodeAs follows:
Exec sp_rename 'table name. [original column name] ', 'new column name', 'column'

**************************************** *********************************
Transact-SQL reference

Sp_rename
Change the name of the user-created object (such as a table, column, or user-defined data type) in the current database.

Example
A. rename a table
In the following example, the customers table is renamed as custs.

Exec sp_rename 'customer', 'custs'

B. rename a column
In the following example, rename the contact title column in the customers table to the title column.

Exec sp_rename 'customer'. [contact title] ', 'title', 'column'

***********

Modify the Database Name

Sp_renamedb [@ dbname =] 'old _ name', [@ newname =] 'new _ name'