DROP TABLE SUPPLIERS;                                                           
CREATE TABLE SUPPLIERS                                                          
   (SUPPNO INTEGER,                                                             
    NAME  CHAR(15),                                                             
    ADDRESS CHAR(33));                                                          
                                                                                
INSERT INTO SUPPLIERS                                                           
   VALUES                                                                       
   (51,'DEFECTO PARTS','16 BUM ST., BROKEN HAND WY');                           
INSERT INTO SUPPLIERS                                                           
   VALUES                                                                       
   (52,'VESUVIUS, INC.','512 ANCIENT BLVD., POMPEII NY');                       
INSERT INTO SUPPLIERS                                                           
   VALUES                                                                       
   (53,'ATLANTIS CO.','8 OCEAN AVE., WASHINGTON DC');                           
INSERT INTO SUPPLIERS                                                           
   VALUES                                                                       
   (54,'TITANIC PARTS','32 LARGE ST., BIGTOWN TX');                             
INSERT INTO SUPPLIERS                                                           
   VALUES                                                                       
   (57,'EAGLE HARDWARE','64 TRANQUILITY PLACE, APOLLO MN');                     
INSERT INTO SUPPLIERS                                                           
   VALUES                                                                       
   (61,'SKY PARTS','128 ORBIT BLVD., SIDNEY AUSTRALIA');                        
INSERT INTO SUPPLIERS                                                           
   VALUES                                                                       
   (64,'KNIGHT LTD.','256 ARTHUR COURT, CAMELOT ENGLAND');                      
                                                                                
SELECT * FROM SUPPLIERS;                                                        
