Query a list of tables

["Campbell, Lance" <lance@xxxxxxxxxxxx>]

What is the SQL to do the following:

 

1)      Return a list of all possible SCHEMA names within a database.

2)      For a given SCHEMA return the list of all table names.

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu