Guide for Developers: SQL Server creating table with clustered index without a primary key

Monday 6 November 2017

SQL Server creating table with clustered index without a primary key

Yes, it is possible to create a clustered index that is not the primary key. Just use a CREATE CLUSTERED INDEX statement.

CREATE TABLE dbo.myTable (
    myTableId int PRIMARY KEY NONCLUSTERED
    myColumn int NOT NULL
)

CREATE CLUSTERED INDEX myIndex ON dbo.myTable(myColumn)

1 comment:

James Zicrov24 February 2021 at 22:12
Thank you so much for providing information about SQL and many other aspects of it to help about solving toughest and most complex IT databases problems and solutions.

SQL Server Load Soap API

ReplyDelete
Replies

Subscribe to: Post Comments (Atom)