var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alter table with PRIMARY KEY
I have an existing table (with records) having the ff: structure:
I want to be modify the structure to add a PRIMARY KEY to the [WorkOrderID] column.
CREATE TABLE [dbo].[TEMP2_WORKORDER] (
[WorkOrderID] [int] IDENTITY (1, 1) NOT NULL ,
[JobType] [varchar] (3) NULL ,
[JobID] [varchar] (10) NULL ,
I was using ALTER TABLE but can't get the right syntax. Please help!
Re: Alter table with PRIMARY KEY
ALTER TABLE dbo.TEMP2_WORKORDER ADD CONSTRAINT
PK_testtable PRIMARY KEY CLUSTERED
Thank you. It did the trick!