alter1.sql

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

ALTER TABLE Author
        ADD CONSTRAINT Aut_PK
        PRIMARY KEY (AutNo);

ALTER TABLE Book
        ADD CONSTRAINT Bk_PK
        PRIMARY KEY (BkISBN);

ALTER TABLE Publisher
        ADD CONSTRAINT Pub_PK
        PRIMARY KEY (PubNo);

ALTER TABLE Authorship
        ADD CONSTRAINT Ashp_PK
        PRIMARY KEY (AutNo, BkISBN);

ALTER TABLE Book
        ADD CONSTRAINT BkPub_FK
        FOREIGN KEY (PubNo) REFERENCES Publisher;

ALTER TABLE Authorship
        ADD CONSTRAINT AshpBk_FK
        FOREIGN KEY (BkISBN) REFERENCES Book;

ALTER TABLE Authorship
        ADD CONSTRAINT AshpAut_FK
        FOREIGN KEY (AutNo) REFERENCES Author;