-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Karen Chu wrote:
> I wish to have something like 'select name from all_tables' in oracle or
> 'select name from sysobjects' in Sybase. Oracle has 'show tables' or
> 'describe <table>' too, but actual meta data is *stored* in systems
> tables. I wonder if MySQL also stores these in system tables or files or
> somewhere else.
MySQL does not currently store this information in system tables. 'SHOW'
/ 'DESCRIBE' are treated as queries by MySQL (just a special case of a
query), so I'm still confused as why they won't work for you. Is there a
reason that you _have_ to use system tables for this functionality?
-Mark
- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+5KWHtvXNTca6JD8RAoI2AKDJoYzsvK2UEnA98ttB7wCm6GxOcwCgot7g
IN4IyjvSI6aApNvx9tEYvHE=
=VPrD
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
