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