terraware
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
dropgeometrytable(catalog_name character varying, schema_name character varying, table_name character varying)
Parameters
Name
Type
Mode
catalog_name
character varying
IN
schema_name
character varying
IN
table_name
character varying
IN
Definition
DECLARE real_schema name; BEGIN IF ( schema_name = '' ) THEN SELECT current_schema() into real_schema; ELSE real_schema = schema_name; END IF; -- TODO: Should we warn if table doesn't exist probably instead just saying dropped -- Remove table EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(real_schema) || '.' || quote_ident(table_name) || ' RESTRICT'; RETURN real_schema || '.' || table_name ||' dropped.'; END;