Blog Post

How to remane a Table in Sql Server

,

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.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating