Export (0) Print
Expand All
Expand Minimize

Add Table Dialog Box (Query and View Designers) (Visual Database Tools)

This dialog box lets you add tables, views, user-defined functions, or synonyms to a query or view.

NoteNote

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.

Tables

Lists the tables you can add to the Diagram pane. To add a table, select it and click Add. To add several tables at once, select them and click Add.

Views

Lists the views you can add to the Diagram pane. To add a view, select it and click Add. To add several views at once, select them and click Add.

Functions

Lists the user-defined functions you can add to the Diagram pane. To add a function, select it and click Add. To add several functions at once, select them and click Add.

Synonyms

Lists the synonyms you can add to the Diagram pane. To add a synonym, select it and click Add. To add several synonyms at once, select them and click Add. (Applies only to SQL Server 2005.)

Refresh

Update the list to include any changes made to the database since the list was last retrieved.

Add

Add the selected item or items.

Community Additions

ADD
Show:
© 2014 Microsoft