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.
this article will help to you.