drop1.sql

来自「python web programming 部分」· SQL 代码 · 共 12 行

ALTER TABLE Authorship DROP CONSTRAINT AshpBk_FK;
ALTER TABLE Authorship DROP CONSTRAINT AshpAut_FK;
ALTER TABLE Authorship DROP CONSTRAINT Ashp_PK;
DROP TABLE Authorship;
ALTER TABLE Book DROP CONSTRAINT Bk_PK;
ALTER TABLE Book DROP CONSTRAINT BkPub_FK;
DROP TABLE Book;
ALTER TABLE Publisher DROP CONSTRAINT Pub_PK;
DROP TABLE Publisher;
ALTER TABLE Author DROP CONSTRAINT Aut_PK;
DROP TABLE Author;