how to query the structure of a database

Is there a standard way (using SQL) to query the structure of a database?

In other words:
one or more query to obtain the names of the non system tables, one or more query, for each table, to obtain field names, field types, field sizes
one or more query for the constraints, indexes etc. independently from the database provider (Oracle, Db2, Sqlserver, etc)

Thanks in advance for any suggestion.

Regards

Massimo Fuccillo Received on Mon Jan 28 2002 - 10:49:23 CET