Creating Synonyms

You can create a synonym when you are creating or altering a table. Synonyms are defined on the Table Options dialog box.

To create a synonym:

1. Display the Create Table or Alter Table dialog box.
2. Click the Options button to display the Table Options dialog box.
3. Click the Create button in the Synonyms group box.

   SQLWizard displays the Create Synonym dialog box.

4. Type a name for the synonym in the Synonym Name field.
5. Click OK to accept the synonym.

   Your new synonym is now listed in the Synonym group box of the Table Options window with a + sign preceding it.

6. Click OK from the Table Options dialog box.
7. Click OK from the Create Table or Alter Table dialog box to create the synonym.
8. Click OK to confirm altering the table.

   SQLWizard creates the new synonym.