描述

删除表及其在geometry_columns中的所有引用。 注意：如果未提供模式，则在模式感知的 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.

DROP TABLE my_schema.my_spatial_table;

The legacy compatibility function performs the equivalent operation.

SELECT DropGeometryTable ('my_schema', 'my_spatial_table');

my_schema.my_spatial_table dropped.

相关信息

AddGeometryColumn, DropGeometryColumn, 第 4.6.2 节 “GEOMETRY_COLUMNS 视图”