how to change table name in SQL server

 Rename table in SQL server

Syntax:
Sp_ rename 'oldtablename','newtablename';

Example:
Sp_ rename 'emp','employee';