18.2. Deleting an Analytical Schema #
Important
Analytical schemas associated with analytical tables or Postgres Pro views cannot be deleted.
Execute the following query:
SELECT metastore.remove_schema('schema_name');
Where schema_name is the name of the analytical schema that is deleted.
Example 18.2.
SELECT metastore.remove_schema('schema_example');
Once the query is executed, pgpro_metastore performs the following actions:
Verifies user privileges.
Creates a new entry in the
pga_snapshotmetadata table and specifies for the analytical schema and all its associated pgpro_metastore objects theend_snapshotvalue in thepga_schemametadata table and other metadata tables.