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