Yes, But on that table primary key should be created with non-clustered i

Can we create clustered index on non primary key column

Question Posted / laxman2610

Answer Posted / laxman2610

Yes, But on that table primary key should be created with
non-clustered index and the columun u want to create a
cluster index is should be unique

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8121

What is a benefit of using an after insert trigger over using a before insert trigger?

939

How to change server name in sql server?

1107

Is natural join and equi join same?

920

what is difference between view and Dip.

2380

Explain something about security and SQL Azure?

110

Does a full backup include transaction log?

919

What are various limitations of the views?

1005

What are system databases into sql server (2005/2008) : sql server database administration

973

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

939

What method is used by the Command classes to execute SQL statements that return single values?

1019

Why do you want to join software field as you have done your BE in Electronics?

2114

Explain the properties of subqueries in sql server?

1032

Why olap is used?

928

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1031