Hey guys, a quick query!
I want to get all the Foreign keys relations defined in my schema. I cna
do it in db-specific fasion (Oracle/SQL Server), but I just chose a more
sophisticated one! I used Connection.OpenSchema. Documents say that the option
adSchemaForeignKeys will get all the foriegn keys. but the following statement:
Set rstRecordset = cnnConnection.OpenSchema(adSchemaForeignKeys, Array(Empty,
Empty, "table1", Empty, Empty, Empty))
gives me no records! Does that mean I dont have any foreign key defined in
my database? Dont tell me.
I also used
Empty, Empty, Empty, Empty, Empty, Empty. but of no use
Any clues?