I heard that there can be only one Clustered Index? I may be wrong, but I am sure I read somewhere.
In one of my SQL Server 2005 table, I have following columns:
SerialNum ------- BigInt -------- Primary Key
District -------- nvarchar(50)
SchemeType ------ nvarchar(50)
When I open the table in design mode using SQL Server Management Studio, I notice that Clustered Index property is enabled for District, whereas it is disabled for SchemeType.
If there can be only one Clustered Index, then why District has this property enabled when SerialNum is already defined as Primary Key?
If there can be more Clustered Indexes, then how to enable this property for SchemeType column?