PRB: Renaming a Table in Table Designer Gets No Warning Message

ID: Q199351

The information in this article applies to:

Microsoft SQL Server version 7.0

SYMPTOMS

Renaming a table through Design Table does not produce the same warning message that appears when you rename a table by right-clicking the table name or clicking Rename on the Action menu in SQL Server Enterprise Manager. If you use Design Table and select the table's Properties page and then change the Table Name entry on the Tables tab and save, the table is renamed, but you will not get a warning message that changing the table's name will cause dependent objects to become invalid.

WORKAROUND

To work around this problem, use the Rename command on the Action menu to rename the table, rather than changing it on the table's Properties page in the Table Designer.

MORE INFORMATION

If you rename a table, objects that have dependencies on that table (such as stored procedures, views, and triggers) become invalid, because they no longer point to the correct table name. Therefore, when you rename a table, the following warning message should appear:

Changing the name of the table will cause stored procedures, views, or triggers that reference the table to become invalid. Are you sure you want to rename the table?

In SQL Server Enterprise Manager, if you click Rename on the Action menu for a table, that message does appear, with the options Yes, No, and View Dependencies. However, this message does not appear if you change the table's name directly on the table's Properties page in the Table Designer.

Additional query words: ren tabl tab

Keywords : SSrvAdmin SSrvEntMan kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbprb