-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdrop-tables.sql
35 lines (35 loc) · 1.63 KB
/
drop-tables.sql
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
drop table BatchDate cascade constraints PURGE;
drop table DimAccount cascade constraints PURGE;
drop table DimBroker cascade constraints PURGE;
drop table DimCustomer cascade constraints PURGE;
drop table DimCompany cascade constraints PURGE;
drop table DimDate cascade constraints PURGE;
drop table DimSecurity cascade constraints PURGE;
drop table DimTime cascade constraints PURGE;
drop table DimTrade cascade constraints PURGE;
drop table DImessages cascade constraints PURGE;
drop table FactCashBalances cascade constraints PURGE;
drop table FactHoldings cascade constraints PURGE;
drop table FactMarketHistory cascade constraints PURGE;
drop table FactWatches cascade constraints PURGE;
drop table Industry cascade constraints PURGE;
drop table Financial cascade constraints PURGE;
drop table Prospect cascade constraints PURGE;
drop table StatusType cascade constraints PURGE;
drop table TaxRate cascade constraints PURGE;
drop table TradeType cascade constraints PURGE;
drop table Audit_ cascade constraints PURGE;
drop table S_Company cascade constraints PURGE;
drop table S_Security cascade constraints PURGE;
drop table S_Financial cascade constraints PURGE;
drop table S_Prospect cascade constraints PURGE;
drop table S_Watches cascade constraints PURGE;
drop table S_Cash_Balances cascade constraints PURGE;
drop table S_Broker cascade constraints PURGE;
drop table S_Customer cascade constraints PURGE;
drop table S_Account cascade constraints PURGE;
drop table S_Trade cascade constraints PURGE;
drop table S_Trade_History cascade constraints PURGE;
drop table S_Holdings cascade constraints PURGE;
drop table S_Daily_Market cascade constraints PURGE;
exit