Rename a table in SQL
I ran to a problem today...I wanted to rename a table on the fly and use the new name in my queries.
I have found an useful command to rename a table in Microsoft SQL server.
The syntax and the command is as below:
I have found an useful command to rename a table in Microsoft SQL server.
The syntax and the command is as below:
exec sp_rename 'existing tablename' , 'new table name'
GO
No comments:
Post a Comment