Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    5

    Unanswered: Views List for a table ??

    Hello Everybody,

    I need to retrieve the list of views associated with a table 'einfo'

    I could not figure out how can I use syscat.tables and syscat.views.


    Please help,

    DB2new

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Try syscat.tabdep

    Andy

  3. #3
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    Select VIEWNAME from syscat.tabdep where BNAME = 'einfo' and BSCHEMA = Schema name for einfo
    IBM Certified Database Associate, DB2 9 for LUW

Posting Permissions

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