Answer / devendra sharma

Yes it is possible that a primary key can be non clustered

create table abc(eid int PRIMARY KEY
NONCLUSTERED,ename varchar(50),vid int)

create clustered index abc_clustered on abc (vid)


now if you will check the index on eid cloumne it will be
unique and vid will have a clustered index.

Give it a try if you don't belive......

Answer / raju

No. If a table have primary key column automatically it is
clustered index. if a table have other than primary key
it have non clustered index. so answer of the question is it
doesn't support non clustered index in the primary key column

Answer / candu

No

Answer / hiral bhatt

No, its not possible to hving Primary key with Non Clusterd
Index, because whenever we have to make a column as Primary
Key, it will create a Clusterd Index on that Column
automatically, it is due to the concept of paging, thats
why we can have only 1 primay key and 1 clusterd index per
Table...Enjoy :-)

Answer / ivee

yes, it is possible

Answer / navneet sharma

Primary cannot be a non clustered index because when you
are creating primary key on a column then by defualt
cluster index will created on that column.

Answer / sql2000

Its Possible, run the below code and have a look...

begin transaction
create table test (col1 int, col2 int)

insert into test values (1, 1)
insert into test values (1, 2)
insert into test values (1, 3)
insert into test values (2, 1)
delete from test where col1 = 2

alter table test
alter column col2 int not null

alter table test
add
constraint [pk_col2] primary key nonclustered(col2) on
[primary]
rollback transaction

Answer / vinoth

Yes,Its Possible.Eg( Select Eid,Did,Ename from Employee)
.Create table with primary key column(Eid).This time
Primary key column ACT As a CLUSTERDE INDEX for Default.

Suppose User directly create Did COLUMN with CLUSTEREDINDEX
at this time Primary key column act as a NONCLUSTEREDINDEX.

Answer / praveen

No, its not possible to hving Primary key with Non Clusterd
Index, because whenever we have to make a column as Primary
Key, it will create a Clusterd Index on that Column
automatically, it is due to the concept of paging, thats
why we can have only 1 primay key and 1 clusterd index per
Table...Enjoy :-)

Answer / samar

Primary key is also known as clusterd index which is
physical structure .And noncluster index is logical
structure .

therefore Primary key cant be a nonclustered index. and
when we are creating primary key on a table system
understands it as creation of clustered index.

this is the reason one table can have one primary key

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

What is ms sql server index?

0 Answers  

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

What do you need to connect php to sql server?

0 Answers  

What is data file in computer?

0 Answers  

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

What is resultset concur_updatable?

0 Answers  

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

What is it unwise to create wide clustered index keys?

0 Answers  

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

Do you know the isolation level that sql server support?

0 Answers  

How can I know what query is executing by by a particural user? (using sp id or any othe way.)

2 Answers