sqlLab4/drops.sql at master · kev405/sqlLab4 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
/* Borrar disparadores*/
DROP TRIGGER IF EXISTS grade_check ON enrols;
DROP TRIGGER IF EXISTS grade_check_up ON enrols;

/* Borrar la vista */
DROP VIEW IF EXISTS better_students;

/* Borrar Procedures*/
DROP PROCEDURE IF EXISTS create_teaches(instructor_idp INT, course_idp INT);
DROP FUNCTION IF EXISTS grade_check();
DROP FUNCTION IF EXISTS grade_check2();

/*Borrar las tablas*/
/*Drop constraints para eliminar llaves*/
ALTER TABLE course_offering DROP CONSTRAINT "FK_course_offering.course_id";
ALTER TABLE enrols DROP CONSTRAINT "FK_enrols.student_id";
ALTER TABLE enrols DROP CONSTRAINT "FK_enrols_offering.course_id";
ALTER TABLE teaches DROP CONSTRAINT "FK_teaches.course_id";
ALTER TABLE teaches DROP CONSTRAINT "FK_teaches.instructor_id";
ALTER TABLE requires DROP CONSTRAINT "FK_requires.main_course";
ALTER TABLE requires DROP CONSTRAINT "FK_requires.prerequisite";

/*Drop tables para borrar las tablas*/
DROP TABLE IF EXISTS "student";
DROP TABLE IF EXISTS "instructor";
DROP TABLE IF EXISTS "course";
DROP TABLE IF EXISTS "course_offering";
DROP TABLE IF EXISTS "enrols";
DROP TABLE IF EXISTS "teaches";
DROP TABLE IF EXISTS "requires";


/*Borrar secuencias*/
DROP SEQUENCE IF EXISTS "student_id_seq";
DROP SEQUENCE IF EXISTS "course_id_seq";