Add Table Dialog Box

Enables you to add tables and views in Query Designer or add tables in Database Designer. This dialog box appears when you are in SQL Server 7.0 Enterprise Manager (SEM).

Options

Add

Adds tables or views.

If you add a table or view that already exists:

• In Query Designer, the duplicate table will be given an alias name. For example, if you add the authors table twice, the second authors table will be called authors1.
  
  
• In Database Designer, you will get a message box warning you that the table already exists on the diagram.

Close

Cancels the addition of a new table or view if you have not yet added anything. Or, closes the dialog box after adding a table or view.