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:

For more information, see the

Informatica Data Archive 6.2 HotFix 2 Data Vault Administrator Guide

.