Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    34

    Unanswered: How to list of tables

    I need a list of all tables available for specific database - can i do through command window ? - how ?

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by dingi
    I need a list of all tables available for specific database - can i do through command window ? - how ?
    LIST TABLES
    LIST TABLES FOR ALL
    LIST TABLES FOR SCHEMA <BLAH>
    SELECT * FROM SYSCAT.TABLES

    Should I continue?
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Feb 2004
    Posts
    34
    Thanks -- its enough for now - will bother u again

Posting Permissions

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