Share via

Creating SQL Server Database Tables

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

After creating a database, you can add tables for storing your data. You can create them in your Microsoft® Access project as described in the following, or you can create them directly in the SQL Server Enterprise Manager.

To create SQL Server database tables in Access

  1. In Access, with the database open, select Tables in the Objects list, and then double click Create table in Design view.

  2. Create your columns.

    Note   To enter data in a SQL Server table, you must set a primary key. Be sure to clear the Allow Nulls option.

  3. Click Save, type a name for the table, and then close the table designer.

    **Note   **For additional information about using Access, refer to the Access online Help.

See Also

Creating Workflow Applications from Databases | Using Access to Create SQL Server Databases