All the information on tables, columns and databases are stored in *SUPRISE* other tables. You can write SQL queries against those system tables to get the information that you are interested without needing any special systems knowledge.

As for the tables that you should be looking at, Try this page to get you started