HeidiSQL is looking for constraints (e.g. foreign key) by examining the information_schema.constraint_column_usage table. Unfortunately, columns will only be returned ...
Three sessions, all open in the same HeidiSQL window. All three to the same MariaDB server. Each of the three with a different SQL user. The third session utilizes a user that does NOT have SELECT ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback