create table snapdeal_orders ( order_Id int not null, -- now we can not add null value in column order_id , not null constraint order_date date, -- "yyyy-mm-dd" is standard format product_name varchar ...