diff options
author | Wilrik de Loose <wilrik@wilrik.nl> | 2008-05-08 19:07:50 (GMT) |
---|---|---|
committer | Wilrik de Loose <wilrik@wilrik.nl> | 2008-05-08 19:07:50 (GMT) |
commit | dc6caf529031dba2dd595b64ee008ffda39737b6 (patch) | |
tree | 9026623a73886e313097561b4bfc09f9cc77b025 /db_demo/sql/drop.sql | |
parent | 4c0c2685a6d564c9a6170b8a56c873104046a832 (diff) | |
download | 2iv55-dc6caf529031dba2dd595b64ee008ffda39737b6.zip 2iv55-dc6caf529031dba2dd595b64ee008ffda39737b6.tar.gz 2iv55-dc6caf529031dba2dd595b64ee008ffda39737b6.tar.bz2 |
Tabel structuur aangemaakt
Diffstat (limited to 'db_demo/sql/drop.sql')
-rw-r--r-- | db_demo/sql/drop.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/db_demo/sql/drop.sql b/db_demo/sql/drop.sql new file mode 100644 index 0000000..9553629 --- /dev/null +++ b/db_demo/sql/drop.sql @@ -0,0 +1,20 @@ +-- drop views (3)
+DROP VIEW vw_turn;
+DROP VIEW vw_test;
+DROP VIEW vw_person;
+
+-- drop sequences (3)
+DROP SEQUENCE seq_person;
+DROP SEQUENCE seq_test;
+DROP SEQUENCE seq_turn;
+
+-- drop user tables (3)
+DROP TABLE tbl_turn;
+DROP TABLE tbl_test;
+DROP TABLE tbl_person;
+
+-- drop constant tables (4)
+DROP TABLE const_gametype;
+DROP TABLE const_block;
+DROP TABLE const_boxsize;
+DROP TABLE const_agegroup;
|