how to query the structure of a database
Date: Mon, 28 Jan 2002 09:49:23 GMT
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