Drop_Nation_Tables_Generate_Script
Prev  12.2. Tiger Geocoder  Next

Name

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.

Synopsis

text Drop_Nation_Tables_Generate_Script(text param_schema=tiger_data);

Description

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

Examples

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;