-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdropDDL.sql
More file actions
18 lines (18 loc) · 885 Bytes
/
dropDDL.sql
File metadata and controls
18 lines (18 loc) · 885 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
ALTER TABLE T_USER DROP FOREIGN KEY FK_T_USER_ACCOUNT_ID
ALTER TABLE T_TRANSACTION DROP FOREIGN KEY FK_T_TRANSACTION_ACCOUNT_ID
ALTER TABLE T_TRANSACTION DROP FOREIGN KEY FK_T_TRANSACTION_STATEMENT_ID
ALTER TABLE T_IDEA DROP FOREIGN KEY FK_T_IDEA_USER_ID
ALTER TABLE T_SHORTSELL DROP FOREIGN KEY FK_T_SHORTSELL_ACCOUNT_ID
ALTER TABLE T_SHORTSELL DROP FOREIGN KEY FK_T_SHORTSELL_TRANSACTION_ID
ALTER TABLE T_STATEMENTSTAKE DROP FOREIGN KEY FK_T_STATEMENTSTAKE_ACCOUNT_ID
ALTER TABLE T_STATEMENTSTAKE DROP FOREIGN KEY FK_T_STATEMENTSTAKE_STATEMENT_ID
ALTER TABLE T_ACCOUNT_T_IDEA DROP FOREIGN KEY FK_T_ACCOUNT_T_IDEA_ideas_ID
ALTER TABLE T_ACCOUNT_T_IDEA DROP FOREIGN KEY FK_T_ACCOUNT_T_IDEA_Account_ID
DROP TABLE T_USER
DROP TABLE T_TRANSACTION
DROP TABLE t_statement
DROP TABLE T_ACCOUNT
DROP TABLE T_IDEA
DROP TABLE T_SHORTSELL
DROP TABLE T_STATEMENTSTAKE
DROP TABLE T_ACCOUNT_T_IDEA