SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON BEGIN TRANSACTION GO ALTER TABLE dbo.TelNumbers ADD SysCode int NOT NULL IDENTITY (1, 1) GO ALTER TABLE dbo.TelNumbers ADD CONSTRAINT PK_TelNumbers PRIMARY KEY CLUSTERED ( SysCode ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] COMMIT