Skip to content

Commit 7fbf88b

Browse files
committed
Optimize SQL query in TDBConnection.GetTableForeignKeys. See https://www.heidisql.com/forum.php?t=36212
1 parent 67b2f81 commit 7fbf88b

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

source/dbconnection.pas

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -5203,7 +5203,7 @@ function TDBConnection.GetTableForeignKeys(Table: TDBObject): TForeignKeyList;
52035203
ColQuery := GetResults('SELECT *'+
52045204
' FROM '+InfSch+'.KEY_COLUMN_USAGE'+
52055205
' WHERE'+
5206-
' CONSTRAINT_SCHEMA='+EscapeString(Table.Database)+
5206+
' TABLE_SCHEMA='+EscapeString(Table.Database)+
52075207
' AND TABLE_NAME='+EscapeString(Table.Name)+
52085208
' AND REFERENCED_TABLE_NAME IS NOT NULL'
52095209
);

0 commit comments

Comments
 (0)