Where you pointed, there is only the name I created for the SCADA to MYSQL connection in the (web/config/database.connections). Thanks you,
do you have more solution ?
It's not possible. What you can do is create separate connections for each schema, not optimal at all btw.
Not sure what everyone is talking about, but those tables and views are all contained within the same database, and you can see all of the views in the database query browser in ignition, except the test table is missing for some reason..
A database schema is essentially a group of tables, views, procedures, and other objects. This organization helps with managing permissions, avoiding naming conflicts, and maintaining clarity in complex databases.
For example, in Microsoft SQL Server, you'll often see schemas like dbo and sys. The dbo (database owner) schema is typically used to store user-created objects—tables, views, and procedures that you create to hold your application’s data. On the other hand, the sys schema contains system-level objects.
What @yaak870 wants is to see the schema name (dbo, sys...) within the table list.
To view schemas in the Database Query Browser, enable the Include Schema in Table Name option. To do this, edit the database connection, then check the Show Advanced Properties box to reveal this setting.
Wow, great finding, didn't know that!
He just wants to see the tables, where currently all he's seeing are the views. If you check the screenshot, you can see the views are there but there's no "test" table when comparing his database management software to the schema objects exposed by ignition
This is what I meant by
As I think the fact that those views and tables are in the same database was missed
I was wondering if they were even on the same server (but I presume they are). OP appears to be using MySQL Workbench but I couldn't figure out how to check the database connection with that.
I'm not sure it's missing! but I'm Executed comment (select * from sys.test) it show value from MYSQL Workbench. if connection error or missing (sys.test) it doesn't show value
Now I create a new Schema, it works.
It was my first time using Database. Thanks for all the help.