Drop table and attributes from a cloud database

Drop table and attributes from a cloud database

  
Hi all,
I have a DEV environment in the outsystems cloud.
I have an eSpace where one of the tables (MENU) had and ID attribute as an integer. Now I want this ID attribute to be a primary key. Also, I deleted another attribute in the same table.

When I try to publish I get the following error:

Publishing Error
Unable to upgrade database schema. Error trying to create primary key on database table 'OSUSR_mxq_Menu'.
Exception: Cannot define PRIMARY KEY constraint on nullable column in table 'OSUSR_MXQ_MENU'.
Could not create constraint. See previous errors.
SQL: ALTER TABLE "OSDEV2"."DBO"."OSUSR_MXQ_MENU" ADD CONSTRAINT "OSPRK_OSUSR_MXQ_MENU" 
PRIMARY KEY CLUSTERED ("ID");
 
 
Exception Details:
[1] Publishing Error: Unable to upgrade database schema. Error trying to create primary key on database table 'OSUSR_mxq_Menu'.
Exception: Cannot define PRIMARY KEY constraint on nullable column in table 'OSUSR_MXQ_MENU'.
Could not create constraint. See previous errors.
SQL: ALTER TABLE "OSDEV2"."DBO"."OSUSR_MXQ_MENU" ADD CONSTRAINT "OSPRK_OSUSR_MXQ_MENU" 
PRIMARY KEY CLUSTERED ("ID");
....

Now, how can I fix this problem without access to the database?

Many, thanks.
 
Hi Helio,

Cut and paste your entity is usually the easy fix. It will create a completly new entity in the database.

Regards,
João Rosado
Hi João,
Very easy way! Works fine!

Thanks for the tip.
Tiago