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


Please Help Members By Posting Answers For Below Questions

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

539


What are indexers?

631


What is pessimistic concurrency?

546


Please differentiate between a local and a global temporary table?

573


What is a result set object returned by mssql_query()?

580






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

541


how to overcome kernel isssues

1174


Can we use where clause in union?

599


What is self contained sub query?

561


What are the dmvs?

575


How do I view a script in sql server?

539


Explain activity monitors

625


what exactly sql injuction.how to overcome.....

2043


How you can change the database name in SQL SERVER?

673


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?

642