how to query the structure of a database

From: Massimo Fuccillo <>
Date: Mon, 28 Jan 2002 09:49:23 GMT
Message-ID: <D8958.18173$>

Hi all

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.


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

Original text of this message