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 <http://webservices.uiuc.edu/>