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
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?
Can we use custom code in ssrs?
How do I uninstall sql server 2014?
What protocol does sql server use?
What is transact-sql language?
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
What is tablesample?
Can primary key be a foreign key?
What is an execution plan? When would you use it?
Give an example of SQL injection attack ?
When multiple after triggers are attached to sql table, how to control the order of execution?
When cursors are useful?
List some case manipulation functions in sql?
Explain about unique identifier data type in sql server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?