Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
You can use the SELECT statement to access virtual tables that contain metadata information. These virtual tables reside in a virtual schema named ADMIN_SCHEMA. The ADMIN_SCHEMA schema resides in the metadata database in the Data Vault.
Use the following syntax to access a virtual table:
SELECT * from ADMIN_SCHEMA.<table name>
Example:
SELECT * from ADMIN_SCHEMA.TABLES
You can access the following virtual tables:
ADMIN_SCHEMA.TABLES
ADMIN_SCHEMA.PARTITIONS
ADMIN_SCHEMA.COLUMNS
ADMIN_SCHEMA.DOMAINS
ADMIN_SCHEMA.PART_LIMITS
ADMIN_SCHEMA.TAB_LIMITS
ADMIN_SCHEMA.HOSTS
ADMIN_SCHEMA.AGENTS
ADMIN_SCHEMA.TASKS
ADMIN_SCHEMA.CLIENTS
ADMIN_SCHEMA.SESSIONS
ADMIN_SCHEMA.USERS
ADMIN_SCHEMA.DATABASES
ADMIN_SCHEMA.ADMINS
ADMIN_SCHEMA.VERSIONS
For more information, see the
Informatica Data Archive 6.2 HotFix 2 Data Vault Administrator Guide