Show Tables;
-
VirtualChicagoLand.com Is Your Chicagoland Resource!
Visit: http://VirtualChicagoLand.com
On Wed, 16 Jan 2002, Bret Ewin wrote:
> I need to know how to get a list of all the tables in a database. In Oracle
> you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list
show tables will get you a list of tables. To get the schema of tables
type 'describe '
J
Bret Ewin wrote:
> I need to know how to get a list of all the tables in a database. In Oracle
> you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list of all
> tables and their schemas. How d
I need to know how to get a list of all the tables in a database. In Oracle
you could "select OWNER, TABLE_NAME from ALL_TABLES" to get a list of all
tables and their schemas. How does one do this in MySQL?
Thanks,
Bret
-
Befor