Then add the columns back in the order you want. In the Index Columns dialog box, remove the columns from the primary key. Select Columns, and then click the ellipses (.) to the right of the property. For more information about fill factors and their uses, see Specify Fill Factor for an Index. If this option is not selected, a unique nonclustered index is created.Įxpand the Fill Specification category and type an integer from 0 to 100 in the Fill factor box. If this option is not available for your index, you must first clear this setting on the existing clustered index. Only one clustered index can exist per table. To create a clustered index for the primary key, select Create as CLUSTERED, and select the option from the drop-down list box. Make sure that your new name does not duplicate a name in the Selected Primary/Unique Key or Index list. In the Indexes/Keys dialog box, select the primary key index from the Selected Primary/Unique Key or Index list.Ĭomplete an action from the following table: To Open the Table Designer for the table whose primary key you want to modify, right-click in the Table Designer, and choose Indexes/Keys from the shortcut menu. Using SQL Server Management Studio To modify a primary key You can modify the primary key of a table by changing the column order, index name, clustered option, or fill factor. You can modify a primary key in SQL Server by using SQL Server Management Studio or Transact-SQL. SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |