DPVENDOR Sample

The DPVENDOR table contains vendor information.

In this section: DPVENDOR Table Definition DPVENDOR Contents

DPVENDOR Table Definition

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

DPVENDOR Contents

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