DropGeometryTable
이전  7.2. 관리 함수  다음

제목

DropGeometryTable — 테이블 및 geometry_columns의 모든 참조를 삭제합니다.

요약

boolean DropGeometryTable(varchar table_name);

boolean DropGeometryTable(varchar schema_name, varchar table_name);

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

설명

테이블 및 geometry_columns에 있는 테이블의 모든 참조를 삭제합니다. 주의: 스키마를 제공하지 않는다면 스키마를 인식하는(schema-aware) pgSQL 설치 상에서 current_schema()를 사용해보십시오.

[주의]

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.

예시

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