Drop_Nation_Tables_Generate_Script — Generates a script that drops all tables in the specified schema that start with
county_all
,
state_all
or state code followed by
county
or
state
.
text
Drop_Nation_Tables_Generate_Script
(
text
param_schema=tiger_data
)
;
Generates a script that drops all tables in the specified schema that start with
county_all
,
state_all
or state code followed by
county
or
state
. This is needed if you are upgrading from
tiger_2010
to
tiger_2011
data.
Availability: 2.1.0
SELECT drop_nation_tables_generate_script(); DROP TABLE tiger_data.county_all; DROP TABLE tiger_data.county_all_lookup; DROP TABLE tiger_data.state_all; DROP TABLE tiger_data.ma_county; DROP TABLE tiger_data.ma_state;