CREATE TABLE suppliers
 ( sno      CHAR (5)   NOT NULL,
   sname    CHAR (20),
   city     CHAR (15),
   status   INTEGER,
   PRIMARY KEY (sno)
 );