FIT 100
vCREATE TABLE VENDOR
(V_CODE FCHAR(5) NOT NULL UNIQUE,
V_NAME VCHAR(35) NOT NULL,
V_CONTACT VCHAR(15) NOT NULL,
V_AREACODE FCHAR(3) NOT NULL,
V_PHONE FCHAR(3) NOT NULL,
V_STATE FCHAR(2) NOT NULL,
V_ORDER FCHAR(1) NOT NULL,
PRIMARY KEY (V_CODE));