Can we know the relations from SQL/MARIADB databases

Posts: 1487

Joined: Tue Jun 14, 2016 07:51 AM

Can we know the relations from SQL/MARIADB databases
Posted: Tue Oct 31, 2017 02:30 PM

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

Using: FWH 23.08 with Harbour

Posts: 1487

Joined: Tue Jun 14, 2016 07:51 AM

Re: Can we know the relations from SQL/MARIADB databases
Posted: Tue Oct 31, 2017 09:41 PM

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

Marc Venken

Using: FWH 23.08 with Harbour

FiveTech Support Forums