Raghavendra Mudugal (7/16/2014)
Koen Verbeeck (7/16/2014)
Unless a clustered index was already defined. 🙂
how you mean? "already"
this simple statement creates a clustered index
CREATE TABLE TT1
(
ID INT PRIMARY KEY,
NAME VARCHAR(10)
);
You can create a table as a heap, create a clustered non-unique index on some columns and then define a primary key.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP