How to create a table (Enterprise Manager)

To create a table

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database in which to create the table.
3. Right-click Tables; then click New Table....
4. In the Choose Name dialog box, enter a name for the table.
5. Fill in the columns as appropriate. Each row represents one column in the table.
6. Right-click any row; then click Properties.
7. Click the Tables tab.
8. Optionally, specify a filegroup on which to create the table:
   • In the Table file group list, select the filegroup on which to place the table.
   • Optionally, in the Text file group list, select a filegroup on which to place any text, image, and ntext columns.
9. Optionally, click New to create any required CHECK constraints.
   • In Constraint expression, enter the text of the constraint.
   • Optionally, in Constraint name, enter a name for the constraint, if different from the default name supplied.

See Also