CREATE TABLE [s13].[datatypes] ( [id] int IDENTITY(1,1) NOT NULL, [bigint] bigint NULL, [binary] binary(8) NULL, [binary16] binary(16) NULL, [bit] bit NULL, [char] char(10) NULL, [char36] char(36) NULL, [date] date NULL, [datetime] datetime NULL, [datetime20] datetime2(0) NULL, [datetime23] datetime2(3) NULL, [datetime27] datetime2(7) NULL, [datetimeoffset0] datetimeoffset(0) NULL, [datetimeoffset3] datetimeoffset(3) NULL, [datetimeoffset7] datetimeoffset(7) NULL, [decimal] decimal(18,0) NULL, [decimal92] decimal(9,2) NULL, [decimal150] decimal(15,0) NULL, [decimal152] decimal(15,2) NULL, [decimal192] decimal(19,2) NULL, [decimal282] decimal(28,2) NULL, [decimal382] decimal(38,2) NULL, [float] float NULL, [geography] geography NULL, [geometry] geometry NULL, [hierarchyid] hierarchyid NULL, [image] image NULL, [int] int NULL, [money] money NULL, [nchar] nchar(10) NULL, [ntext] ntext NULL, [numeric] numeric(18,0) NULL, [numeric92] numeric(9,2) NULL, [numeric150] numeric(15,0) NULL, [numeric152] numeric(15,2) NULL, [numeric192] numeric(19,2) NULL, [numeric282] numeric(28,2) NULL, [numeric382] numeric(38,2) NULL, [nvarchar] nvarchar(255) NULL, [nvarcharmax] nvarchar(max) NULL, [real] real NULL, [smalldatetime] smalldatetime NULL, [smallint] smallint NULL, [smallmoney] smallmoney NULL, [sql_variant] sql_variant NULL, [sysname] nvarchar(128) NULL, [text] text NULL, [time0] time(0) NULL, [time3] time(3) NULL, [time7] time(7) NULL, [timestamp] timestamp NULL, [tinyint] tinyint NULL, [uniqueidentifier] uniqueidentifier NULL, [varbinary] varbinary(1024) NULL, [varchar] varchar(255) NULL, [varcharmax] varchar(max) NULL, [xml] xml NULL, CONSTRAINT [PK_datatypes] PRIMARY KEY ([id]) );