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
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.
See Also
Other Resources
How to: Create Update Queries (Visual Database Tools)