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!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment