DropGeometryTable
Indietro  7.2. Funzioni di gestione delle tabelle  Avanti

Nome

DropGeometryTable — Rimuove una tabella e tutte le sue referenze da geometry_columns

Sinossi

boolean DropGeometryTable(varchar table_name);

boolean DropGeometryTable(varchar schema_name, varchar table_name);

boolean DropGeometryTable(varchar catalog_name, varchar schema_name, varchar table_name);

Descrizione

Rimuove una tabella spaziale e tutte le sue referenze da geometry_columns. Nota: utilizza la funzione PostgreSQL current_schema() se lo schema non è passato come argomento.

[Avvertimento]

DropGeometryTable is retained for backward compatibility and is not recommended for new applications. Use the standard DROP TABLE command instead. The geometry_columns view updates automatically from the system catalogs.

Changed: 2.0.0. Retained for backward compatibility after geometry_columns became a view of the system catalogs.

Esempi

Use standard SQL to drop a table containing geometry columns. The geometry_columns view updates automatically.

Code
DROP TABLE my_schema.my_spatial_table;

The legacy compatibility function performs the equivalent operation.

Code
SELECT DropGeometryTable ('my_schema', 'my_spatial_table');
Output
my_schema.my_spatial_table dropped.