How to Rename table In SQL Server
In SQL Server there no direct query to rename table. It can be possible using built in procedure in SQL server.
The following syntax help you to raname a table using procedure.
EXEC sp_rename 'old_table_name', 'new_table_name'
Rename table Using SSMS
Another way to rename a table is Rght Click the table from SQL Server Management Studio.
No comments:
Post a Comment