I have an existing table (with records) having the ff: structure:
CREATE TABLE [dbo].[TEMP2_WORKORDER] (
[WorkOrderID] [int] IDENTITY (1, 1) NOT NULL ,
[JobType] [varchar] (3) NULL ,
[JobID] [varchar] (10) NULL ,
I want to be modify the structure to add a PRIMARY KEY to the [WorkOrderID] column.
I was using ALTER TABLE but can't get the right syntax. Please help!
ThanksALTER TABLE dbo.TEMP2_WORKORDER ADD CONSTRAINT
PK_testtable PRIMARY KEY CLUSTERED
(
WorkOrderID
)|||Thank you. It did the trick!
Showing posts with label structurecreate. Show all posts
Showing posts with label structurecreate. Show all posts
Sunday, March 25, 2012
Alter table with PRIMARY KEY
Subscribe to:
Posts (Atom)