USE [LABORATORY] GO /****** Object: Table [dbo].[tblabRFsections] Script Date: 1/22/2020 5:23:05 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tblabRFsections]( [Code] [int] IDENTITY(1,1) NOT NULL, [SectionName] [varchar](50) NULL, [SectionCode] [varchar](5) NULL, CONSTRAINT [PK_tblabRFsections] PRIMARY KEY CLUSTERED ( [Code] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] ) ON [PRIMARY] GO insert into tblabRFsections (SectionName,SectionCode) values ('Clinical','Z')