I found a way out of the issue.
I had to add one column at a time and then save the table design then drop the table and finally create the table again….
Exhausting
However thanks for your time
CREATE TABLE dealerdetails
(dealerid tinyint NOT NULL
,gstno tinytext NOT NULL
,orgname varchar NOT NULL
,dealername varchar NOT NULL
,dealeremail tinytext NOT NULL
,dealermobile tinyint NOT NULL
,dealeraddress text NOT NULL
,dealerpincode tinyint NOT NULL
,note tinytext NULL
,PRIMARY KEY (dealerid)
);
CREATE UNIQUE INDEX dealerid ON dealerdetails (dealerid);
Thanks for your reply. Here it goes
