表结构的增删查改

ALTER TABLE "table_name"
[改变方式]

 

ALTER table customer add Gender char(1);

 

ALTER table customer change Address Addr char(50);

 

ALTER table customer modify Addr char(30);

 

ALTER table customer drop Gender;

 

MySQL :
CREATE TABLE ORDERS
(Order_ID integer,
Order_Date date,
Customer_SID integer,
Amount double,
Primary Key (Order_ID),
Foreign Key (Customer_SID) references CUSTOMER(SID));

 

已经存在了：

ALTER TABLE ORDERS
ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(sid);