crome man i've another trouble here, say i do this:
CREATE TABLE REVIEW (
R_ID VARCHAR(4) NOT NULL,
ISBN VARCHAR(15) NOT NULL,
Rating NUMERIC(2),
PRIMARY KEY(R_ID,ISBN),
FOREIGN KEY (R_ID) REFERENCES AUTHOR (A_ID));
next say i want to drop the foreign key constraint from the above...