Changes in table alias, not change the mysql table

cbrianso

There is this element created as alias_table

this create a this table in the api

but if I change the relationships, so that it depends on another table, and leave it like this

Amb publish all the elements, the api table, are the same.
Is there any prior step that needs to be taken so that the generated table is the new one, and does not maintain the old structure?

Alex

Super easy and simple. You'll need to remove the existing table and construct a new one.

DROP TABLE `ts_fauna` CASCADE;

And publish it again with a new structure and data...
OR
If you have mixed published data, you can delete old columns easily.

ALTER TABLE ts_fauna DROP COLUMN column_name;

When column_name is the name of the column that you want to remove.

The only Dédalo-related aspect here is that it will create the structure defined in the diffusion ontology if it doesn't already exist and transform the data into this structure. However, it's not a MySQL/MariaDB manager. The Dédalo main database is PostgreSQL, and any diffusion databases (MySQL, MariaDB, Virtuoso, MongoDB, or any other diffusion system) are merely duplicates of the main data in a defined and specific manner. These databases are typically used as read-only data from the API REST or other read procedures.

You can see all SQL commands here.

Or making a internet searches similar to: how delete a table in SQL or any other question about the SQL management.

I hope is clear

Best