CREATE TABLE [dbo].[Cricket_data] ( [Player_Batting_Order] float NULL, [Player_Name] varchar(255) NULL, [Playing] bit NOT NULL DEFAULT ((0)) ) ON [PRIMARY] WITH ( DATA_COMPRESSION = NONE ) GO CREATE TABLE [dbo].[Cricket_data_No_Default] ( [Player_Batting_Order] float NULL, [Player_Name] varchar(255) NULL, [Playing] bit NOT NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = NONE ) GO CREATE TABLE [dbo].[Cricket_data_No_Default_Null] ( [Player_Batting_Order] float NULL, [Player_Name] varchar(255) NULL, [Playing] bit NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = NONE ) GO CREATE TABLE [dbo].[Cricket_data_Null] ( [Player_Batting_Order] float NULL, [Player_Name] varchar(255) NULL, [Playing] bit NULL DEFAULT ((0)) ) ON [PRIMARY] WITH ( DATA_COMPRESSION = NONE ) GO CREATE TABLE [dbo].[Cricket_data1] ( [Player_Batting_Order] float NULL, [Playing] bit NOT NULL DEFAULT ((0)), [Player_Name] varchar(255) NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = NONE ) GO CREATE TABLE [dbo].[Cricket_data1_No_Default] ( [Player_Batting_Order] float NULL, [Playing] bit NOT NULL, [Player_Name] varchar(255) NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = NONE ) GO CREATE TABLE [dbo].[Cricket_data1_No_Default_Null] ( [Player_Batting_Order] float NULL, [Playing] bit NULL, [Player_Name] varchar(255) NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = NONE ) GO CREATE TABLE [dbo].[Cricket_data1_Null] ( [Player_Batting_Order] float NULL, [Playing] bit NULL DEFAULT ((0)), [Player_Name] varchar(255) NULL ) ON [PRIMARY] WITH ( DATA_COMPRESSION = NONE ) GO