SQL Tutorial: How To Rename Table Name In SQL Server

How To Rename Table Name In SQL Server

Rename Table Name In SQL Server is very easy. When we change our application design, then may be some times we need to change our table name as well to keep up with the new design .You just need a single line of code to rename table name.

sp_rename 'Old_table_name','New_table_name'

Just run the above query and see the result. you are done with renaming table in sql server. You can also learn how to create a stored procedure in sql server.

 

Nahidur Rahman Rifath

Passionate Software Engineer, Content Writer, Reader

3 Comments

Leave a Reply

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