Can we create clustered index on non primary key column
Answer Posted / ashok
we can creta clustered index on non primary column.
create table abc(eid int,ename varchar(50))
create clustered index abc_clustered on abc (eid)
Is This Answer Correct ? | 67 Yes | 9 No |
Post New Answer View All Answers
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What are indexers?
What is pessimistic concurrency?
Please differentiate between a local and a global temporary table?
What is a result set object returned by mssql_query()?
What is the security principal at the database level that represents your session?
how to overcome kernel isssues
Can we use where clause in union?
What is self contained sub query?
What are the dmvs?
How do I view a script in sql server?
Explain activity monitors
what exactly sql injuction.how to overcome.....
How you can change the database name in SQL SERVER?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?