ODBCDatabase.ForeignKeys
From Xojo Documentation
| You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site! |
Method
ODBCDatabase.ForeignKeys(PrimaryTable as String, ForeignTable as String) As RecordSet
Supported for all project types and targets.
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.
Notes
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.