CREATE TABLE "Cricket_data" ( "Player_Batting_Order" DOUBLE, "Player_Name" VARCHAR(255), "Playing" DECIMAL(1,0) NOT NULL WITH DEFAULT 0 ) GO CREATE TABLE "Cricket_data1" ( "Player_Batting_Order" DOUBLE, "Playing" DECIMAL(1,0) NOT NULL WITH DEFAULT 0, "Player_Name" VARCHAR(255) ) GO CREATE TABLE "Cricket_data1_No_Default" ( "Player_Batting_Order" DOUBLE, "Playing" DECIMAL(1,0) NOT NULL, "Player_Name" VARCHAR(255) ) GO CREATE TABLE "Cricket_data1_No_Default_Null" ( "Player_Batting_Order" DOUBLE, "Playing" DECIMAL(1,0), "Player_Name" VARCHAR(255) ) GO CREATE TABLE "Cricket_data1_Null" ( "Player_Batting_Order" DOUBLE, "Playing" DECIMAL(1,0) WITH DEFAULT 0, "Player_Name" VARCHAR(255) ) GO CREATE TABLE "Cricket_data_No_Default" ( "Player_Batting_Order" DOUBLE, "Player_Name" VARCHAR(255), "Playing" DECIMAL(1,0) NOT NULL ) GO CREATE TABLE "Cricket_data_No_Default_Null" ( "Player_Batting_Order" DOUBLE, "Player_Name" VARCHAR(255), "Playing" DECIMAL(1,0) ) GO CREATE TABLE "Cricket_data_Null" ( "Player_Batting_Order" DOUBLE, "Player_Name" VARCHAR(255), "Playing" DECIMAL(1,0) WITH DEFAULT 0 ) GO ALTER TABLE "Cricket_data" ADD CONSTRAINT "SYS_C0014769" CHECK ("Playing" IS NOT NULL) GO ALTER TABLE "Cricket_data1" ADD CONSTRAINT "SYS_C0014770" CHECK ("Playing" IS NOT NULL) GO ALTER TABLE "Cricket_data1_No_Default" ADD CONSTRAINT "SYS_C0014771" CHECK ("Playing" IS NOT NULL) GO ALTER TABLE "Cricket_data_No_Default" ADD CONSTRAINT "SYS_C0014772" CHECK ("Playing" IS NOT NULL) GO