28.4. Retrieving Columns of an Analytical Table #
Execute the following query:
SELECT column_id, column_name, column_type
FROM 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 where columns are created.snapshot_ID: The ID of the snapshot from thepga_snapshotmetadata table.