How to drop primary key from a table

Question

my table structure is as given below

create table qwe
(
id int primary key,
employee varchar(100)
)

How to delete Primary key from the ID column . I have tried the following :

alter table qwe
alter column id int

I know I can remove this key by going into design mode, but is there a way to delete using SQL statement.

score 1 · Accepted Answer · edited May 23 '17 at 10:24

1

Try this

ALTER TABLE qwe
DROP CONSTRAINT id

edited May 23 '17 at 10:24

Community

answered Mar 18 '15 at 12:14

Ajay

can not drop a constraint as i have not defined or given a constraint name – sam Mar 18 '15 at 12:16

score 0 · Answer 2 · answered Mar 18 '15 at 12:08

0

Try this:

ALTER TABLE qwe DROP CONSTRAINT id;

In case this gives an error, try:

ALTER TABLE qwe NOCHECK CONSTRAINT id;

answered Mar 18 '15 at 12:08

shauryachats

its giving me error: – sam Mar 18 '15 at 12:09
Msg 3728, Level 16, State 1, Line 2 'id' is not a constraint. Msg 3727, Level 16, State 0, Line 2 Could not drop constraint. See previous errors. – sam Mar 18 '15 at 12:09
I have edited the answer. – shauryachats Mar 18 '15 at 12:12
i am still getting err – sam Mar 18 '15 at 12:14
Msg 4917, Level 16, State 0, Line 1 Constraint 'id' does not exist. Msg 4916, Level 16, State 0, Line 1 Could not enable or disable the constraint. See previous errors. – sam Mar 18 '15 at 12:14

2 Answers2