Juli's note
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment