re: how to get all tables

2002-10-14 Thread Egor Egorov
Huan, Monday, October 14, 2002, 8:03:36 AM, you wrote: HH> What is the sql command which is the same as command HH> "show tables" ? There is no command to see all tables in all databases. You can see list of tables only for a single database at time. HH> Other database stores all tables in a sy

how to get all tables

2002-10-13 Thread Huan He
Hello, What is the sql command which is the same as command "show tables" ? Other database stores all tables in a system table, is there one in mysql ? Thanks, Tom __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.y