This topic has not yet been rated - Rate this topic

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ