Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Update Table Dialog Box (Visual Database Tools)

This dialog box allows you to specify the table to be updated.

This dialog box appears if more than one table is displayed in the Diagram pane when you change a query's type to be an Update query.

Select the table to update, and then choose OK.\


If the table is published for replication, you must make schema changes using the Transact-SQL statement ALTER TABLE or SQL Server Management Objects (SMO). When schema changes are made using the Table Designer or the Database Diagram Designer, it attempts to drop and recreate the table. You cannot drop published objects, therefore the schema change will fail.

Community Additions

© 2015 Microsoft