Can we create clustered index on non primary key column
Answer Posted / vikas kant
Yes We can create clustered index on a non primary key
column by using the following syntax--:
create clustered index abc_index on Table1(student_class)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the exact numeric data type in sql?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Where are full-text indexes stored?
What is cursors? And what are the different types of cursor?
What are cascading parameters in ssrs reports?
What are out-of-range errors with date and time literals?
What is a print index?
Explain transaction server distributed transaction?
How to execute the cursor queries with "open" statements?
What are the steps to process a single select statement?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
How to check status of stored procedure in sql server?
What are the general features of sql server management studio? : sql server management studio
Mention the different types of replication in sql server.