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.