How to create an index when creating a table (Enterprise Manager)

To create an index when creating 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. On the Indexes/Keys tab, click New.
8. In the Column name list, click the columns that are part of the index.
9. Optionally:
   • In Index name, enter a name for the index if different from the default name supplied.
   • In Index file group, select a filegroup on which to create the index.
   • Select Create UNIQUE to make this index a unique constraint. Or click Index to make this index unique.
   • Select Create as CLUSTERED to make this index clustered.
   • In Fill factor, specify how full SQL Server should make the leaf level of each index page during index creation.

See Also

Creating an Index