Dummy table DDL SQL for table to act as Source/Sink/Target/Destination in ETL Products

/****** Object:  Table [dbo].[dummyTableAllDataTypes]    Script Date: 18/08/2019 7:00:42 PM ******/
DROP TABLE [dbo].[dummyTableAllDataTypes]
GO

/****** Object:  Table [dbo].[dummyTableAllDataTypes]    Script Date: 18/08/2019 7:00:42 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[dummyTableAllDataTypes](
[nvarcharMax] [nvarchar](max) NULL,
[nvarcharMax2] [nvarchar](max) NULL,
[exactNumericDataType2Follow] [nvarchar](max) NULL,
[bigint1] [bigint] NULL,
[bit1] [bit] NULL,
[decimal1] [decimal](18, 0) NULL,
[int1] [int] NULL,
[money1] [money] NULL,
[smallMoney1] [smallmoney] NULL,
[numeric1] [numeric](18, 0) NULL,
[smallint1] [smallint] NULL,
[tinyint1] [tinyint] NULL,
[ApproxNumeric2Follow] [varchar](8000) NULL,
float1 float null,
real1 real null,
DateTime2Follow nvarchar(max) null,
date1 date null,
datetime1 datetime null,
datetime2 datetime2 null,
datetimeoffset1 datetimeoffset null,
smalldatetime1 smalldatetime null,
time1 time null,
CharacterstringsDataType2Follow varchar null,
char1 char null,
varchar1 varchar null,
tex1 text null,
UnicodecharacterstringsDataTypes2Follow varchar null,
nchar1 nchar null,
nvarchar1 nvarchar null,
ntext1 ntext null,
BinaryString2Follow varchar null,
binary1 binary null,
varbinary1 varbinary null,
image1 image null,
moreDataTypeJustNamesToFollow varchar null,
cursor1 varchar null,
rowversion1 rowversion null,


) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO