yes we can create clusterd index on non primary key. but the primary key

Can we create clustered index on non primary key column

Question Posted / madhav

Answer Posted / madhav

yes we can create clusterd index on non primary key. but
the primary key must should be a non clusteresd index

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the New in SQL server 2008?

917

How can you check the version of sql server?

1047

Explain Normalization and DE normalization

1053

What is 'write-ahead log' in sql server 2000 ?

989

What is dml command?

887

Explain primary key?

898

What is collation sensitivity?

986

How many types of functions are there in sql server?

875

What is the difference between value type and reference type?

870

What is a unique key constraint?

971

Who is the owner of a schema in ms sql server?

1008

What is postgresql server?

941

What is local temp table?

895

What factors you will consider calculating the storage requirement for that view?

895

What is a bit datatype?

924