-- Create table
create table Vendor
of Vendor
tablespace KAOHE123
storage
(
initial 64M
minextents 1
maxextents 100
);
-- Add comments to the columns
comment on column Vendor.vend_id
is '唯一的供应商ID';
comment on column Vendor.vend_name
is '供应名';
comment on column Vendor.vend_address
is '供应商的地址';
comment on column Vendor.vend_city
is '供应商的城市';
comment on column Vendor.vend_state
is '供应商的州';
comment on column Vendor.vend_country
is '供应商的国家';
comment on column Vendor.vend_zip
is '供应商的邮编';
-- Create/Recreate primary, unique and foreign key constraints
alter table Vendor
add constraint Vendor primary key (VEND_ID);