Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Question Unanswered: List of tables in a specific database via SMI table query?

    I would like to be able to query for all tables in a specific database (excluding the system tables). How do I go about doing that? The query "select tabname from systables" give all of the tables. What I want is the same table names list/results as I would get if I were to do a dbschema or dbexport.

    Is this possible?? On IDS 9.21.UC3.

    Thanks so much...

  2. #2
    Join Date
    Jun 2003

    Thumbs up

    Try this query;
    select tabname from systables where tabid > 99;
    Above query gives all Your application tables (ie) other than systables

Posting Permissions

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