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;
原文：https://www.cnblogs.com/xjyxp/p/11162720.html