How to get database metadata information (i.e. existing tables and columns in tables)

[Chris Brat]

Hi,

Is it possible to retrieve details about the database, specifically a
list of the tables in the database; and then to retrieve the columns
and their types for the tables?

Is this dependant on the database? 

Thanks
Chris