Tools > Relationships displays too many tables

[theber]

I am using Base to connect to mariadb databases. I use different Linux distributions, and usually LibreOffice 24. The problem that I describe here occurs in OpenSUSE and Arch.

I have the problem with a new database with 4 tables, call it databaseA. When I open the menu Tools > Relationships, there are about 40 tables from most - but not all - of my databases on display. In the past I would only see the tables from the active database, which is what I would expect.
I have tried editing the content.xml file for databaseA, but this does not help. For example, I removed all the references to the tables of databaseB, but these tables from databaseB are still displayed in the Relationships window for databaseA.
Furthermore, in some older databases that correctly show only the active tables in Relationships, the content.xml file lists tables from some different databases.

I hope I have described this clearly. Is there something I can do for this?

[Villeroy]

Under Tools><Table Filter you can hide tables, so they are hidden from the tables section, the relations window, the wizards and Calc/Writer’s data source window.

[RobertG]

Showing more than one database for MariaDB/MySQL depends on the driver you use for connect to the database.
You couldn’t connect the tables of one database to tables of another database, but you could define the relationships for all tables of the databases, which are shown by the driver.
There are some people, who need this connections to more than one database in one Base file. So all this databases with tables could be selected in relationships.

[theber]

Thanks @Villeroy , and also @RobertG . It seems clear to me now.
Just one small point: hiding the tables with the Table Filter does indeed work for the Relationships window, which was my problem. However, the tables are still visible in the tables section. But I think it has always been like this, so it doesn’t bother me.

[iplaw67]

If you have admin rights to the databases in question, then you will see all of the schema in the tables window. This can’t be changed, to my knowledge.