1 files changed, 89 insertions, 0 deletions
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
+/
+