Skip to Content (Press Enter)
UserImage.jpg
SYSLINE
464Views
2Comments
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
0
0
03 Sep 2020
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP
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

 

See solution in context
0
0
03 Sep 2020
Copy Link
UserImage.jpg
Peter L

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.

0
0
03 Sep 2020
Copy Link
2024-07-05 14-16-55
Daniël Kuhlmann
 
MVP
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

 

0
0
03 Sep 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.