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.\

Note Note

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

ADD
Show:
© 2014 Microsoft