can primery key be a non clustered index?
Answers were Sorted based on User's Feedback
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......
Is This Answer Correct ? | 18 Yes | 0 No |
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
Is This Answer Correct ? | 22 Yes | 10 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 :-)
Is This Answer Correct ? | 11 Yes | 6 No |
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.
Is This Answer Correct ? | 8 Yes | 5 No |
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
Is This Answer Correct ? | 3 Yes | 0 No |
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.
Is This Answer Correct ? | 2 Yes | 0 No |
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 :-)
Is This Answer Correct ? | 4 Yes | 6 No |
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
Is This Answer Correct ? | 1 Yes | 4 No |
Can you insert NULL in unique column?
What are the five characteristics of good data?
Difference between 2NF &3NF ?
How do I shrink an ldf file?
How do I manually uninstall an instance of sql server 2016?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is difference between process and thread? Explain lazy writer funcationality.
What is the purpose of sql profiler in sql server? : sql server database administration
What is exporting utility?
List out different types of normalizations in sql server and explain each of them?
Can you get second highest salary from the table?
what is difference between primary key and Unique