Retrieve Relationships between tables?

[MartinTeefy]

Hi,

I accessing Access, MSSQL, MYSQL & SQLite in a windows server via a dcom link for my helpdesk system offering clients the database of their choice.

The problem is i've now added SQLite to the supported list but because i've coded the back-end to use ADO for the other databases but some of the functionality does not port well to accessing SQLite via a vb wrapper library i'm using.

I'd like to replicate the following ADO code:

' Restrictions:array(PK_TABLE_CATALOG, PK_TABLE_SCHEMA, FK_TABLE_CATALOG, FK_TABLE_SCHEMA, FK_TABLE_NAME)
Set GetADORelations = Cnn.OpenSchema(adSchemaForeignKeys, Array(Empty, Empty, Empty, Empty, Empty))

where GetADORelations is an ADO recordset.

Is there a way to do this with SQLite i.e. get the relationships between tables for primary & foreign keys?

Thanks
Martin