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;