private string JoinColumnUsesIndex(string tableName, string columnName) { var indexFiles = TableUtils.GetForeignKeyData(DatabaseName, tableName); foreach (var file in indexFiles) { if (file[1] == columnName) { return("FK_" + tableName + "_" + file[0]); } } return(""); }