Friday 28 October 2016

Re-name a Table in Sql Server

We can rename the table name with the help of SP_RENAME SP. Below is syntax
SP_RENAME  'old table name', 'New table name'
See the example

Just I am Renaming the Emp table.
SP_RENAME  'dbo.Emp', 'dbo.Emp_Rename'
  
 Now name has been changed

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts