In this article we will explain what is temporary table in SQL Server is or how to create temporary table in SQL server with example.


SQL sp_RENAME syntax is used to change the name of a table. Sometimes, we choose non-meaningful name for the table. So it is required to be changed.

Let's see the syntax to rename a table from the database

sp_RENAME 'old_table_Name', 'new_table_name'

Let us take an example of a table named "Customer", now due to some reason we want to change it into table name " Consumer".

sp_RENAME 'Customer', 'Consumer'

when you execute following massage will show:

Caution: Changing any part of an object name could break scripts and stored procedures.

I hope this article will help to you.

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.

You may also like