Can we know the relations from SQL/MARIADB databases

[Marc Venken]

I can open and edit many tables from a online database (Prestashop) from my server.

I know that Prestashop has relations, indexes, .... from many of his tables.

EX.

Table : PS_products must have a relation or so from table PS_ATTRIBUTES

Can we somehow know with a command/function in SQL if there is a relation between tables ?

[Marc Venken]

I see that the program HeidiSql mentioned on the forum gives most of the info.