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

↑ Back to top