PSQuery Metadata Table Names
Sometimes it is nice to view the metadata of your PSQuery definitions.
List of Tables
You can search the PSRECDEFN table for all records beginning with PSQRY.
SELECT RECNAME, RECDESCR, PARENTRECNAME FROM PSRECDEFN WHERE RECNAME LIKE 'PSQRY%' AND RECTYPE = 0
The below list is as of 8.54, with a description of each. We’ll then follow up this post with some unique tricks about the meta data tables (coming soon).
Core Query Definition Tables
- PSQRYDEFN-Query Definition
- PSQRYEXPR-Query Expression
- PSQRYBIND-Query Prompt
- PSQRYSELECT-Query Select
- PSQRYRECORD-Query Record
- PSQRYFIELD-Query Field
- PSQRYFIELDDEP-Query Field Dependency
- PSQRYCRITERIA-Query Criteria
Other Tables
- PSQRYFAVORITES-Query Manager Favorites Table
- PSQRYXFORM-Query Transformation
- PSQRYDEL-Query Definition Deletes
- PSQRYLINK-Unknown
- PSQRYPREFS-Unknown
- PSQRYFLAGS-Query Global Flags Table
- PSQRYSTATS-Query RunTime Statistics
- PSQRYEXECLOG-Query RunTime Log
- PSQRYTRANS-Unknown
- PSQRYACCLSTRECS-Query Access Record List
- PSQRYDEFNLANG-Query Definition Alt. Language
- PSQRYBINDLANG-Query Prompt Alternate Lang.
- PSQRYFIELDLANG-Query Field Alternate Language
