From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!

ODBCDatabase.ForeignKeys(PrimaryTable as String, ForeignTable as String) As RecordSet

Supported for all project types and targets.

Returns a RecordSet containing either a list of foreign keys in the specified table (columns in the specified table that refer to primary keys in other tables), or a list of foreign keys in other tables that refer to the primary key in the specified table.


Not all ODBC drivers support this feature. If it is not supported, it will return Nil.

Microsoft provides additional information about the SQLForeignKeys ODBC function.