Table of Contents

Search

  1. Version 6.4.3
  2. Version 6.4 HotFix 2
  3. Version 6.4 HotFix 1
  4. Version 6.4
  5. Version 6.3
  6. Version 6.2 Hot Fix 2
  7. Version 6.2 Hot Fix 1
  8. Version 6.2
  9. Version 6.1.1
  10. Version 6.1

Metadata

Metadata

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
.


Updated July 03, 2018