How can I get table names in MySql 4.0?

Question

In MySql 4.0.x, there are no view "information_schema".
In this case, how can I list the tables in the database using select query? without using MySql terminal command such as "show tables"

http://dev.mysql.com/doc/refman/4.1/en/show-tables.html – parvus Dec 16 '13 at 06:13 — parvus, Dec 16 '13 at 06:13

score 0 · Accepted Answer · edited Dec 16 '13 at 07:38

0

I do not think there is any way in MySql 4.0. You have to upgrade your MySql to 5.0 to get "information_schema" or you can use "show tables", but that you do not want to use.

edited Dec 16 '13 at 07:38

Himanshu Jansari

30,115
28
106
129

answered Dec 16 '13 at 06:29

A Paul

7,797
2
27
57

It seems impossible without using informatino_schema, so I think you are right. – daehee Dec 16 '13 at 07:05

How can I get table names in MySql 4.0?

1 Answers1