Inconsistent database table and entity definitions warning: how to resolve this?

Inconsistent database table and entity definitions warning: how to resolve this?

Hello everyone,

I have this situation in my project:

Inconsistent database table and entity definitions: Column <table>.<column> exists in database, but there is no corresponding attribute in entity '<entity>' : the entity definition, in your eSpace, does not include the attribute associated with < column >. You deleted this attribute from entity , but OutSystems Platform kept the corresponding column in the table. This inconsistency only occurs if the eSpace has been published with the previous entity definition.

Do one of the following: Drop column from the table, in the database, and publish the eSpace again; add a new attribute to entity with the same name as column ; or ignore the warning."

How can I drop a column from the table in the database?

Thanks for any help.


The platform will NEVER delete anything from the database.  THis is done intentionally to prevent data loss and also to allow for rollback to previous versions of your applications.

You need to remove the column manually using e.g. SQL Server Management Studio to edit the table, or by writing a script that will drop the column and then executing the script.

Another alternative is to use the DBCleaner component available from the forge.
Thanks for the answer Izak!

I'm a begginer in OS enviromment and I'm using the trial version of the product. Is possible to use SQL Server Management with the trial version to acces the database? How can I access the Database with SQL Server? What's the "credentials" i have to use and where I can find them?

Thanks for the tips!

If you are using the trial version in the cloud, I'm afraid the DBCleaner option is going to be your only option.  Connecting to directly to the database is only possible if you are running your own platform installation.
Thanks Izak!

I will go explore the DBCleaner solution and try to figure how to drop one column on the database using that tool.