Microsoft KB Archive/199351

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

Article ID: 199351

Article Last Modified on 10/27/2000

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q199351



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: kbprb KB199351

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.