How to remane a Table in Sql Server

Vivek's SQL Notes

Vivek johari is currently a Analyst and have more that 5.5 yeras of experience in database. He has Master degree in Computer and also he is Microsoft certified Sql DBA (MCTS)& Microsoft certified SQl BI professional(MCTS). He is also Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work basically involved designing and optimization of the Database.He has also published many database articles on his blog Technologies with Vivek Johari.

How to remane a Table in Sql Server

Posted on 2 January 2012
Comments
Briefcase
Print

To rename a column in a SQL Table following command can be reused:
SP_RENAME 'old table name', 'New table name'

For example, if we want to rename the table from employee to employeemaster, following command can be used.

SP_RENAME 'employee', 'employeemaster'

This command will rename the table from employee to employeemaster.