Query a list of tables

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