Tuesday, February 7, 2012

Primary Key in SQL for existing table

add primary key using query

ALTER TABLE dbo.tablename
ADD PRIMARY KEY (columname)

remove primary key using query

ALTER TABLE Table1
DROP CONSTRAINT [PK_Table1_Col1]

0 comments:

Post a Comment