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 authentication modes does sql server support? : Sql server database administration

1182

Explain different types of collation sensitivity?

1030

What are cascading parameters in ssrs reports?

236

What function does a database engine serve in the sql server?

1079

What are the advantages of user defined function?

1041

How can windows applications connect to sql servers via odbc?

1175

what is isolation level at dead lock?

2209

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

982

What to check if a User database is locked?

1113

Where cross join is used?

1027

What is the difference between nvl and nvl2?

1025

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1121

What is a with(nolock)?

1024

Explain something about security and SQL Azure?

134

How do I find the sql server instance name?

1013