39.4. Retrieving Columns of an Analytical Table #
On the server with the metadata catalog, execute the following command:
SELECT column_id, column_name, column_type
FROM axe_catalog.pga_column
WHERE
table_id = table_ID AND
snapshot_ID >= begin_snapshot AND
(snapshot_ID < end_snapshot OR end_snapshot IS NULL)
ORDER BY column_order;
Where:
table_ID: The ID of the analytical table from thepga_tablemetadata table that contains the column.snapshot_ID: The ID of the snapshot from thepga_snapshotmetadata table.