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.