Accessing TDV and Business Directory System Tables
Most system tables are in the Studio resource tree under /Desktop/Composite Data Services/Databases/system/. Tables unique to Business Directory (and some tables visible also on the Studio resource tree) can be accessed from BD under HELP > SYSTEM TABLES. After opening a system table, you can show its contents, which include selected metadata of resources defined for use by client applications.
Note: System tables are virtual tables. They map to a physical database table, a view, a structure in server memory, or a combination of these. TIBCO reserves the right to change the system tables at any time.
For system tables, what you see depends on the rights and privileges you have. Studio users are limited to executing SQL SELECT statements on these tables. The rights and privileges to change system tables are locked, to prevent changes that could compromise functionality and performance.
For several tables, you see no rows unless you have the ACCESS_TOOLS right. If you have this right, you see rows for all resources for which you have the READ privilege. Users with both ACCESS_TOOLS and READ_ALL_STATUS rights can see all rows.
To access a current list of system tables
1. Open Studio as the admin user.
2. In the resource tree, expand /Desktop/Composite Data Services/Databases/system/.
3. Select the system table you want to examine.
4. Double-click the table to open it.
5. Use the workspace pane to review details about the system table.
You can use Studio to view system table data. After opening the system table, click Show Contents.