I want to create a table with a sql statement that will have the dbname and the tables in that db (like the sysobjects in SQL Server or the user_tables in Oracle). Is there a way to do this? I know about show tables and show databases but how do I get this information into a table with a sql statment?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I get a list of databases and tables
- Thread starter scubaray
- Start date
- Status
Similar threads
