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


Please Help Members By Posting Answers For Below Questions

How do you identify a foreign key?

821


Explain contrast amongst grouped and non-bunched records?

778


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

756


What is encryption key?

100


What is the process of normalization?

830


Explain atomicity?

768


Describe in brief databases and sql server databases architecture.

738


Can one drop a column from a table?

805


You are doing log shipping due to some reasons it is failing. How you will proceed from there

1821


How to download and install microsoft .net framework version 2.0?

824


How to create a testing table with test data in ms sql server?

804


Define Joins?

829


How do I find information about the install locations for the various instances running on a computer?

837


What is 3nf normalization form?

817


What is function of master database?

110