创建和操作表

创建表

CREATE TABLE OrderItems
(
order_num INTEGER NOT NULL,
order_item INTEGER NOT NULL,
prod_id CHAR(10) NOT NULL DEFAULT 1
);

更新表

ALTER TABLE Vendors
ADD vend_phone CHAR(20);

 

ALTER TABLE Vendors
DROP COLUMN vend_phone;

 

删除表

DROP TABLE CustCopy;