When you design the fields and keys for a new table, you need to save the table in the database before you can use it. After you have saved a table, it appears in the list of tables shown in Object Designer.
To save a table
-
With the focus on Table Designer, on the File menu, click Save.
The Save As dialog box opens.
-
In the ID field, enter a number that will serve as a unique table identification.
Note There are restrictions about which numbers you can use. Contact your Microsoft Certified Partner for information.
-
In the Name field, enter the name of the table.
-
Clear the Compiled check box if you do not want the table to be compiled when it is saved.