Rename Table in SqlServer

This Blog show you how to rename table name in Sql Server.

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'