Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Unanswered: Column use by plans/package

    Can I query the system tables to find out if a particular column is used by any plan/package?

  2. #2
    Join Date
    Aug 2004
    SYSPACKDEP will show the package dependencies at the table/view/synonym/tablespace/index/alias/function/stored procedure level. You can query the STMT column of the SYSPACKSTMT and look for references to the column name in the associated sql statement unless the column is not explicitly named in the statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts