Xojo Documentation Xojo Documentation

Method

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

Supported for all project types and targets.

Returns a RowSet 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.

References

SQLForeignKeys ODBC function