CREATE TABLE DPVENDOR
    (VENDOR_NUMBER    INTEGER      NOT NULL,
     VENDOR_NAME      CHAR(5)      NOT NULL,
     VENDOR_CITY      CHAR(5)      NOT NULL);

  SELECT * FROM DPVENDOR;
  VENDOR_NUMBER VENDOR_NAME VENDOR_CITY
  ------------- ----------- -----------
              1 ACME        NY
              2 STAR        OMAHA
              3 MMT         NY
              4 PIKE        MIAMI