Renaming Database Objects

Rename user objects (including user-defined datatypes) with sp_rename.

Warning!   After you rename a table or column, you must redefine all procedures, triggers, and views that depend on the renamed object.
Parent topic: Identifiers