How to Rename a column,Table or Database in SQL

How to Rename a columnName,Table or a Database in SQL

To Rename a columnName or TableName creating table is to use SP_Rename System Procedure

To Rename a DBName SP_Renamedb System Procedure

Below we will create a table then we will apply SP_Rename to change ColumnName Table name

create table Employee_rename

(Empid int ,EmpName nvarchar(50),EmpSalary float)

insert into Employee_rename values(1,'Amit','5000'),(2,'Sumit','6000'),(3,'Raj','8000'),(4,'vijay','9000'),(5,'suresh','10000')

select * from Employee_rename

--Rename a ColumnName 1parameter tablename.oldcolumnname 2 parameter NewcolumnName

sp_rename 'Employee_rename.EmpName','EmployeeName'

select * from Employee_rename

--Rename a table name 1parameter old tablename 2 parameter Newtable Name

sp_rename 'Employee_rename','Emp_rename'

select * from Emp_rename

--Rename a Database name 1parameter old dbname 2 parameter NewDB Name

sp_renamedb 'Testing','Testingnew'

Alternative way to Rename DBName-Rightclick DBName from Object Explorer -Rename

Alternative way to Rename Table-Rightclick TableName from Object Explorer -Rename

Alternative way to Rename Column -Rightclick TableName-Design-Change ColumnName-Save the Table Name

Note: For Table and column Name we have used SP_Rename Procedure, but to Rename DB

we have Used Sp_Renamedb Stored Procedure

After testing change your db ,TableName and columnName back to PreviousName