16.4. Deleting an Analytical Table #
Execute the following query:
SELECT metastore.remove_table('table_name');
Where table_name is the name of the analytical table that will be deleted.
Example 16.5.
SELECT metastore.remove_table('table_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 table and all its associated pgpro_metastore objects theend_snapshotvalue in thepga_tablemetadata table and other metadata tables.