Navigation :

Drop_Nation_Tables_Generate_Script

Drop_Nation_Tables_Generate_Script
Prev   13.1. 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 stae 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;

See Also

Loader_Generate_Nation_Script

Prev   Up   Next
Drop_Indexes_Generate_Script  Home  Drop_State_Tables_Generate_Script