Can we create clustered index on non primary key column
- 20 Answers
- 51470 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / vidit
Yes, But on that table primary key should be created with
non-clustered index and the columun u want to create a
cluster index is should be unique
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What are the advantages of using a stored procedure?
How to invoke a trigger on demand?
Does view occupy space?
what is the system function to get the current user's user id? : Sql server database administration
What is a transact-sql statement batch in ms sql server?
What does dml stand for?
What are .mdf files?
Explain concepts of analysis services?
What is format parameter in ssrs?
What is a trace frag? Where do we use it?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is extended stored procedures?
What is transact-sql ddl trigger?
What are the different methods available under sqlcommand class to access the data?
