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

    Unanswered: How do I get Table Owner (DB2)?

    Can you help me with the SQL for any given login to get the table owner for a given table and database alias?

    Thank you.

  2. #2
    Join Date
    May 2003
    That information is provided in the syscat.tables view. Consult the SQL Reference Vol 1, Appendix D for more information about the SYSCAT views.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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