Primary Keys Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
Primary key constraints make sure that no duplicate values or NULLS are entered in the columns you specify. You can use primary key constraints to enforce uniqueness and referential integrity. A table can only have a single primary key constraint.
The dialog box lets you specify the owner and table on which you want to place the primary key constraint.
To create a new primary key using a wizard:
- Open a creation wizard for a primary key. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - Primary Keys (SQL Server) - Properties.
- Columns panel - Primary Keys (SQL Server) - Properties.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Primary Keys (SQL Server) - Properties
When creating or editing a primary key, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Table Owner and Table Name |
Choose the owner and name of the table in which the primary key is being created. |
Name |
Provide a name of the primary key being created. |
Build Online |
Enabling this feature specifies that the ONLINE=ON clause is used when creating this object and can subsequently be used when rebuilding or dropping this object. |
Max degree of parallelism |
Lets you specify a MAXDOP index operation value, limiting the number of processors used in parallel plan execution. |
Clustered |
Enable or disable clustering. With this check box enabled, subsequent rebuild and drop operations offer an online option. |
File Group |
If you do not specify a filegroup, Microsoft SQL Server creates the index in the default filegroup. |
Fill Factor |
This specifies how full each index page that’s storing data should be. The fill factor is a percentage value between 0 and 100. |
Primary Keys (SQL Server) - Columns
From the Column dropdown, select a column for the primary key and specify a Sort option. To add more columns, click the New button and then follow the steps in the last instruction. Use the Delete button to drop columns.