Microsoft Business Intelligence
Pages
Home
SSIS
SQL SERVER
SSAS
SSRS
Friday, 28 October 2016
Re-name a Table in Sql Server
We can rename the table name with the help of SP_RENAME SP. Below is syntax
SP_RENAME 'old table name', 'New table name'
See the example
Just I am Renaming the Emp table.
SP_RENAME
'dbo.Emp'
,
'dbo.Emp_Rename'
Now name has been changed
No comments:
Post a Comment
If you have any doubt, please let me know.
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Popular Posts
No comments:
Post a Comment
If you have any doubt, please let me know.