· 8 years ago · Feb 27, 2018, 07:14 AM
1IF NOT EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[Schema].[TableName]') AND type in (N'U'))
2BEGIN
3
4CREATE TABLE [Schema].[TableName](
5 [PrimaryKeyName] [INT] IDENTITY(1,1) NOT NULL,
6 [FieldName] [NVARCHAR](50) NOT NULL,
7 CONSTRAINT [PK_Name] PRIMARY KEY CLUSTERED
8(
9 [PrimaryKeyName] ASC
10)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
11) ON [PRIMARY]
12
13END