Can we create clustered index on non primary key column
- 20 Answers
- 51775 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / rima
NO.If the table has the primary key column, then by default
it will have a clustered index on that primary key
cloumn.So if you want to create a clustered index on non
primary key column then you have to create it before
setting a column as the primary key column or u have to
delete the clustered Primary key columns index to create a
new one.but it is recommended to have a clustered index on
primary key column.
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Define magic tables in sql server?
What are the default system databases in sql server 2000?
What do you mean by data integrity?
What do we need queues in sql service broker?
How can we determine what objects a user-defined function depends upon?
What is sub-query in sql server?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What are the new features are introduced in sql server 2012 reporting services?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is the rdl file?
Where the sql logs gets stored?
What is data modification?
Do you know what are the restrictions that views have to follow?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
