From 33613a85afc4b1481367fbe92a17ee59c240250b Mon Sep 17 00:00:00 2001 From: Sven Eisenhauer Date: Fri, 10 Nov 2023 15:11:48 +0100 Subject: add new repo --- Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql | 89 +++++++++++++++++++++++++++ 1 file changed, 89 insertions(+) create mode 100644 Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql (limited to 'Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql') diff --git a/Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql b/Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql new file mode 100644 index 0000000..38d6429 --- /dev/null +++ b/Bachelor/Datenbanken 2/Praktikum3/bibdrop.sql @@ -0,0 +1,89 @@ +/*==============================================================*/ +/* Database name: CONCEPTUALDATAMODEL_1 */ +/* DBMS name: ORACLE Version 9i */ +/* Created on: 29.03.2006 09:46:49 */ +/*==============================================================*/ + + +alter table AUDIO + drop constraint FK_AUDIO_INHERITAN_LEIHOBJE +/ + + +alter table AUSLEIHE + drop constraint FK_AUSLEIHE_RELATIONS_LEIHOBJE +/ + + +alter table AUSLEIHE + drop constraint FK_AUSLEIHE_RELATIONS_ENTLEIHE +/ + + +alter table AUTOR_BUCH + drop constraint FK_AUTOR_BU_AUTOR_BUC_BUCH +/ + + +alter table AUTOR_BUCH + drop constraint FK_AUTOR_BU_AUTOR_BUC_AUTOR +/ + + +alter table BUCH + drop constraint FK_BUCH_INHERITAN_LEIHOBJE +/ + + +alter table ZEITSCHRIFT + drop constraint FK_ZEITSCHR_INHERITAN_LEIHOBJE +/ + + +drop index RELATIONSHIP_4_FK +/ + + +drop index RELATIONSHIP_5_FK +/ + + +drop index AUTOR_BUCH2_FK +/ + + +drop index AUTOR_BUCH_FK +/ + + +drop table AUDIO cascade constraints +/ + + +drop table AUSLEIHE cascade constraints +/ + + +drop table AUTOR cascade constraints +/ + + +drop table AUTOR_BUCH cascade constraints +/ + + +drop table BUCH cascade constraints +/ + + +drop table ENTLEIHER cascade constraints +/ + + +drop table LEIHOBJEKT cascade constraints +/ + + +drop table ZEITSCHRIFT cascade constraints +/ + -- cgit v1.2.3