Renames user-created tables, columns, indexes, constraints (unique, primary key, foreign key, and check), stored procedures, and functions.
Optionally, owner-name can be specified as part of object-name as owner-name.object-name, where owner-name is the name of the owner of the object being renamed. If owner-name is not specified, the user calling sp_iqrename is assumed to be the owner of the object. The object is successfully renamed only if the user calling sp_iqrename has the required privileges to rename the object.
If the object to be renamed is a column, index, or constraint, you must specify the name of the table with which the object is associated. For a column, index, or constraint, object-name can be of the form table-name.object-name or owner-name.table-name.object-name.
The sp_iqrename stored procedure renames user-created tables, columns, indexes, constraints (unique, primary key, foreign key, and check), and functions.
If you attempt to rename an object with a name that is not unique for that type of object, sp_iqrename returns the message “Item already exists.”
sp_iqrename does not support renaming a view, a procedure, an event or a data type. The message “Feature not supported.” is returned by sp_iqrename, if you specify event or datatype as the object-type parameter.
You can also rename using the RENAME clause of the ALTER TABLE statement and ALTER INDEX statement.
sp_iqrename shweta.titles, books
sp_iqrename shweta.books.id, isbn, column
sp_iqrename books.idindex, isbnindex, index
sp_iqrename books.prim_id, prim_isbn, constraint