Can we create clustered index on non primary key column
Answer Posted / pavan kumar
YES, We can create a clustered index on a non-primary
column. Check the folowing queries...
CREATE TABLE EMPLOYEES
(
empid int NOT NULL CONSTRAINT ix_pkEMPLOYEES PRIMARY KEY
NONCLUSTERED
, name varchar(25) NOT NULL
, age tinyint NOT NULL
)
CREATE CLUSTERED INDEX ixcEMPLOYEES ON EMPLOYEES (name)
Is This Answer Correct ? | 57 Yes | 6 No |
Post New Answer View All Answers
How do you identify a foreign key?
Explain contrast amongst grouped and non-bunched records?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is encryption key?
What is the process of normalization?
Explain atomicity?
Describe in brief databases and sql server databases architecture.
Can one drop a column from a table?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
How to download and install microsoft .net framework version 2.0?
How to create a testing table with test data in ms sql server?
Define Joins?
How do I find information about the install locations for the various instances running on a computer?
What is 3nf normalization form?
What is function of master database?