Rename Table in SqlServer

The script for renaming any object (table, sp etc) :

sp_RENAME '[Oldtablename]' , '[Newtablename]'

For example if my table name is class and i want to rename class with NewClass then the script will be like

sp_RENAME 'class', 'NewClass'
Ebook Download
View all
Learn
View all