Re: list of tables in a database

2002-01-16 Thread jr
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

Re: list of tables in a database

2002-01-16 Thread John Kemp
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

list of tables in a database

2002-01-16 Thread Bret Ewin
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