SqlBool FindSchJoin(const String& tables)
Finds a join condition based in REFERENCE attributes of .sch files for a list of tables tables separated by comma. Function runs two phases of matching foreign keys, in the first phase it performs a match based on the name too - the same named columns or foreign key is referenced_table + '_' + referenced_primary_key (e.g. PERSON_ID matches ID of table PERSON) are match. If no match is found in the first phase, in second phase, any correct foreign key matches. If there are more matching columns, first column in .sch definition is used.
Vector<String> GetSchTables()
Returns a list of all tables defined by .sch schema files.
Vector<String> GetSchColumns(const String& table)
Returns all columns for table defined by .sch schema files.
|