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
List some of the rules that apply to creating and using a ‘view’
When would you use it?
Which data type columns are the best candidates for full-text indexing?
Can primary key be a foreign key?
Tell me about pre-defined functions of sql?
Do you know what is sql service broker?
How many types of stored procedures are there in sql server?
Define left outer join in sql server joins?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What is the security principal at the server level that represents your session?
How fixed length strings are truncated and padded?
Disadvantages of the indexes?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Define master database?