DropGeometryColumn
Précédent  7.2. Fonctions de gestion des tables  Suivant

Nom

DropGeometryColumn — Supprime une colonne géométrique d'une table spatiale.

Synopsis

text DropGeometryColumn(varchar table_name, varchar column_name);

text DropGeometryColumn(varchar schema_name, varchar table_name, varchar column_name);

text DropGeometryColumn(varchar catalog_name, varchar schema_name, varchar table_name, varchar column_name);

Description

Removes a geometry column from a spatial table. Note that schema_name will need to match the f_table_schema field shown by the geometry_columns view.

[Avertissement]

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

Cette méthode implémente la spécification OGC Simple Features Implementation Specification for SQL 1.1.

Cette fonction prend en charge la 3D et ne supprime pas l'indice z.

Cette méthode prend en charge les types Circular String et Curve.

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

Exemples

Use standard SQL to drop the geometry column. The geometry_columns view updates automatically.

Code
ALTER TABLE my_schema.my_spatial_table DROP COLUMN geom;

The legacy compatibility function performs the equivalent operation.

Code
SELECT DropGeometryColumn ('my_schema', 'my_spatial_table', 'geom');
Export de raster
my_schema.my_spatial_table.geom effectively removed.