Tuesday, 29 September 2015

How to rename the existing table in SQL server?

After the table creation ,it is also possible to change the table name in SQL server.

Syntax : 

SP_RENAME '[EXISTING TABLE NAME]','[NEW TABLE NAME]'

Example :

SP_RENAME 'Student','StudentDetails'

Now the table name will be changed from Student to StudentDetails in the executed Database.

No comments:

Post a Comment