Can we create clustered index on non primary key column
Answer Posted / selvaraj.v
No, Because Constraints must have integrity. These are,
Clustered and Non-Clustered. So, to use Primary key with
any one Clustered or Non-Clustered index.
Example in SQL Server 2000:
Query :
-------
create table BookDetails
(
Book_ID int identity(1,1) not null clustered,
Book_Title varchar(20),
Book_Type varchar(15),
Book_Author varchar(25),
Book_Edition float,
Book_Publisher varchar(20),
Book_Pub_Year datetime,
Book_Price int
)
Answer:
-------
Server: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'clustered'.
Prevent this Error To use Clustered Primary Key:
------------------------------------------------
Query In SQL Server 2000:
-------------------------
create table BookDetails
(
Book_ID int identity(1,1) not null primary key clustered,
Book_Title varchar(20),
Book_Type varchar(15),
Book_Author varchar(25),
Book_Edition float,
Book_Publisher varchar(20),
Book_Pub_Year datetime,
Book_Price int
)
Answer:
-------
The command(s) completed successfully.
Is This Answer Correct ? | 4 Yes | 21 No |
Post New Answer View All Answers
Explain Geography datatype in SQL Server
What is the use of partition by in sql server?
What are data driven subscriptions?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is field with example?
how would you troubleshoot blocking? : Sql server database administration
Can the “if update (colname)” statement be used in a delete trigger?
Can you please differentiate between a primary key and a unique key?
What is the difference between insensitive and scroll cursor?
Explain the advantages of merge replication?
What is serializable?
What are number line correlation administrators will use while working with a subquery?
Find nth lowest salary or get nth lowest salary?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is an indexed view?