Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 55400 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 will be the maximum number of index per table?
What are drilldown reports?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is the difference between a local and a global temporary table?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
Explain sub-query?
How to use column default values in insert statements in ms sql server?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Explain stored procedure?
List out the differences between global and local temp tables in sql server?
How to generate create view script on an existing view?
What is trigger explain with program?
What number sorts of privileges are accessible in sql?
Can you explain important index characteristics?
