30
Views
2
Comments
Solved
Remove column database
Question

Hello everyone,


I am seeing these annoying messages in the IDE, the documentation guides you to remove the columns in the database. But how can I do this if I do not have access to the (infra) environment of Outsystems?


Is there any way to drop the columns?


I tried to use "SQL Component" but was unsuccessful.


Message:

Inconsistent database table and entity definitions: column 'OSUSR_y2m_Product.LOCATIONID' exists in database, but there is no corresponding attribute in entity 'Product'.


Thank you very much.

Marcelo

warns.png

mvp_badge
MVP
Rank: #18
Solution

Hi Marcelo,

To add to what Peter mentioned correctly, here is an intresting article on the subject of "Database implications after manipulating entities and attributes".

Regards,

Daniel

 

Rank: #484

Hi Marcelo,

Check this forge component out: https://www.outsystems.com/forge/component-overview/423/dbcleaner

OS does not delete columns by default in case a rollback is required.

mvp_badge
MVP
Rank: #18
Solution

Hi Marcelo,

To add to what Peter mentioned correctly, here is an intresting article on the subject of "Database implications after manipulating entities and attributes".

Regards,

Daniel