Friday, May 20, 2011

ADD DROP Primary key on a SQL table

alter table DataUpdate_DTS
Add CONSTRAINT PK_ptno PRIMARY KEY (ptno)
GO


alter table DataUpdate_DTS
drop CONSTRAINT PK_DataUpdate_DTS
GO
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)