Page 1 of 1

list of all tables and fields in database

Posted: Wed Sep 04, 2002 10:32 am
by noguru
Hi

How do I retrieve a list of all the tables and fields that are in my database? What mysql functions can be used for this?

Thanks

Posted: Wed Sep 04, 2002 11:40 am
by Tzicha

Code: Select all

SHOW TABLES
THat shows the tables in your current database

Code: Select all

DESCRIBE <tablename>
That gives a description of a table

For better results check the MySQL manual:
http://www.mysql.com/doc/

Posted: Wed Sep 04, 2002 12:54 pm
by noguru
thanx

i actually meant to say "what functions are to be used in php?", but i have sorted that out eventually using mysql_list_tables and mysql_field_name.

i've managed to connect with the command line as well :lol:
after typing "show tables" and enter, you must actually type "go" enter or else nothing will be displayed 8)

thanx for the help