Objects and Dependencies
Almost everything in a database is an object; this includes tables, constraints, views, functions, stored procedures, and data types. Inevitably, there will come a time when you need to work on these at the object level: from renaming, to moving to a different schema, to determining dependencies between objects. This chapter covers maintaining and working with database objects at the object level.
30-1. Changing the Name of a Database Object
You need to change the name of an object in a database.
Utilize the system stored procedure sp_rename to rename an object in the ...