Can we create clustered index on non primary key column

Answer Posted / vikas kant

Yes We can create clustered index on a non primary key
column by using the following syntax--:

create clustered index abc_index on Table1(student_class)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List some of the rules that apply to creating and using a ‘view’

685


When would you use it?

779


Which data type columns are the best candidates for full-text indexing?

782


Can primary key be a foreign key?

799


Tell me about pre-defined functions of sql?

883


Do you know what is sql service broker?

748


How many types of stored procedures are there in sql server?

759


Define left outer join in sql server joins?

733


What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

771


What is the security principal at the server level that represents your session?

808


How fixed length strings are truncated and padded?

744


Disadvantages of the indexes?

779


Why do we use sql limitations? Which constraints can we use while making a database in sql?

772


explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

852


Define master database?

759