Drop_Nation_Tables_Generate_Script

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;