DropGeometryColumn
이전  7.2. 관리 함수  다음

제목

DropGeometryColumn — 공간 테이블에서 지오메트리 컬럼을 제거합니다.

요약

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);

설명

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.

[주의]

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.

This method implements the OGC Simple Features Implementation Specification for SQL 1.1.

This function supports 3d and will not drop the z-index.

This method supports Circular Strings and Curves.

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

예시

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');
래스터 출력
my_schema.my_spatial_table.geom effectively removed.