Can we create clustered index on non primary key column

Answer Posted / sandeep

Yes, We can, only thing is that, we can create clustered
index only on one key.If table contains any clustered index
on any key(even on primary or on unique key) just drop it
and create it on desired key. after it you can create a non
clustered index on primary or on unique key.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

764


Can we use custom code in ssrs?

813


How do I uninstall sql server 2014?

699


What protocol does sql server use?

725


What is transact-sql language?

789


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1739


What is tablesample?

794


Can primary key be a foreign key?

804


What is an execution plan? When would you use it?

752


Give an example of SQL injection attack ?

774


When multiple after triggers are attached to sql table, how to control the order of execution?

794


When cursors are useful?

789


List some case manipulation functions in sql?

805


Explain about unique identifier data type in sql server?

704


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

774