Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Mint 18.2 using LO v6.1.0.3 currently (various other versions work the same).

The only connector in Base which seems to allow use of Tools->Relationships GUI is the native connector. Both JDBC and ODBC report:

image description

Using a Native connector (SDBC) I have no problem creating or deleting Foreign Keys.

Foreign Keys can be listed, created or deleted using SQL (see manual for syntax).

There is also MySQL Workbench. This has many options for manipulating Schema and selections to show what keys are established (along with Triggers, Stored Procedures and much more). There is also a handy graphical modeling tool to design & convert to a schema.

Then there is Workbench/J which allows connection to many different DB's and has capabilities to transfer data from one DB to another along with DB maintenance & SQL. There is no modeling tool here. Connections are typically JDBC.

Hello,

Mint 18.2 using LO v6.1.0.3 currently (various other versions work the same).

The only connector connectors in Base which seems to allow use of Tools->Relationships GUI is the native connector. connector and MySQL(JDBC). Both JDBC and ODBC connectors from MySQL report:

image description

Using a Native connector (SDBC) I have no problem creating or deleting Foreign Keys.

Can also use MySQL(JDBC) connector in Base without a problem (just tried adding & deleting).

Foreign Keys can be listed, created or deleted using SQL (see manual for syntax).

There is also MySQL Workbench. This has many options for manipulating Schema and selections to show what keys are established (along with Triggers, Stored Procedures and much more). There is also a handy graphical modeling tool to design & convert to a schema.

Then there is Workbench/J which allows connection to many different DB's and has capabilities to transfer data from one DB to another along with DB maintenance & SQL. There is no modeling tool here. Connections are typically JDBC.