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 *


8 + 7 =

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>