SELECT * FROM $SYSTEM.DBSCHEMA_CATALOGS
SELECT * FROM $SYSTEM.TMSCHEMA_TABLES
SELECT * FROM $SYSTEM.DISCOVER_CALC_DEPENDENCY
SELECT * FROM $SYSTEM.TMSCHEMA_MEASURES
SELECT * FROM $SYSTEM.TMSCHEMA_RELATIONSHIPS
SELECT * FROM $SYSTEM.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS WHERE LEFT(TABLE_ID, 2) = 'R$'
SELECT * FROM $SYSTEM.TMSCHEMA_HIERARCHIES
SELECT * FROM $SYSTEM.TMSCHEMA_LEVELS
SELECT * FROM $SYSTEM.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS WHERE LEFT ( TABLE_ID, 2 ) = 'U$'
SELECT *                                  FROM $SYSTEM.TMSCHEMA_COLUMNS
SELECT * FROM $SYSTEM.DISCOVER_STORAGE_TABLE_COLUMNS WHERE COLUMN_TYPE = 'BASIC_DATA'
SELECT * FROM $SYSTEM.DISCOVER_STORAGE_TABLES WHERE LEFT ( TABLE_ID, 2 ) = 'H$'
SELECT * FROM $SYSTEM.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS WHERE RIGHT ( LEFT ( TABLE_ID, 2 ), 1 ) <> '$'
SELECT * FROM $SYSTEM.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS WHERE LEFT ( TABLE_ID, 2 ) = 'H$'
SELECT * FROM $SYSTEM.TMSCHEMA_CALCULATION_GROUPS
SELECT * FROM $SYSTEM.TMSCHEMA_CALCULATION_ITEMS
SELECT * FROM $SYSTEM.TMSCHEMA_FORMAT_STRING_DEFINITIONS
SELECT * FROM $SYSTEM.TMSCHEMA_ROLES
SELECT * FROM $SYSTEM.TMSCHEMA_TABLE_PERMISSIONS
SELECT * FROM $SYSTEM.TMSCHEMA_ALTERNATE_OF_DEFINITIONS
SELECT * FROM $SYSTEM.TMSCHEMA_DATA_SOURCES
select * from $SYSTEM.TMSCHEMA_PARTITIONS
SELECT * FROM $SYSTEM.DISCOVER_PROPERTIES
SELECT * FROM $SYSTEM.DISCOVER_MEMORYUSAGE