How to rename a table in MS SQL Server using query?


We can change table name using sp_rename of MS SQL Server. Below is the syntax of command used to rename a table:

sp_RENAME 'Old_Table_Name', 'New_Table_Name'

The above statement will rename Old_Table_Name to New_Table_Name.

 

Comments & Responses

Leave a Reply

Your email address will not be published. Required fields are marked *

*


− 7 = 2

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>