It's perhaps useful to mention what database system(s) you are querying, and what exact info you want to get out of it (instead of just 'everything').

It may be more practical to directly query the database, either by the tables in the schema 'information_schema' (as prescribed by the SQL standard) or in any DBMS-specific tables/views.