How to drop constraints in the sql server table?
by
Thamilselvanj
on
Jan 17, 2012
Category:
SQL Server
|
Views:
23
|
Points:
25
|
Silver ★
|
|
|
we can use alter syntax to drop constraints in the sql server table, see the below sample constraints in the table and how to drop by using alter syntax.
create primary constraint:
CREATE TABLE testtbl(
colm1 int NOT NULL,
colm2 VARCHAR(50),
CONSTRAINT PK_colm1 PRIMARY KEY (colm1)
);
drop primary constraint:
ALTER TABLE testtbl DROP CONSTRAINT PK_colm1;
|
Like this code? Bookmark and Share:
|
|
|
|
No Response found!
|
|
|
|
|