"Richard A. DeVenezia" <[EMAIL PROTECTED]> wrote: > I'm running 4.1.1a-alpha-max-nt using innodb tables with foreign keys . > I know how to use SHOW TABLE STATUS to see the referential linkages in the > COMMENT column. > > Supppose I am typing away in MySQL monitor: > Q: Is there a way to create a table from the SHOW TABLE STATUS command ?
No, but you can use output of SHOW CREATE TABLE command. > > Q: Does v5 have system views that are equivalent to SHOW xyz commands ? > Nope. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]