Your problem is on the ID, where don't let you delete the table? if so, you must change the delete rule of the property's property ID to ignore(if you want to keep the data) or delete(if you want to remove).

Can you give more details?

Regards,

Márcio C.

Hi,

If your user have permissions, you can use a TRUNCATE statement.

TRUNCATE TABLE {EntityName};

Hello Julian 

To delete the data from Entity... first look into the Entity Delete Rule and it should be Ignore (If you want to delete the data anyhow and "Ignore" will keep the relative data in other tables.)

Then try to delete the rows or use  TRUNCATE TABLE {EntityName}; direct in SQL

This might work for you :)

Hi @Julien Garcia,

To reset a table primary key auto number you need to truncate the table.

SQL Server - https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql?view=sql-server-ver15

Oracle - https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_10007.htm#SQLRF01707

Guys, the table trunc only works on on-premise with enough permissions. In OutSystems hosted cloud environments you will never have sufficient database permissions to do this.

One option you have is to cut paste the entity in your module. This will generate a new table in the database.

With a search on the forum you would have find this answer probably multiple times.

Hello julien, 

if above any thing is not working than you direct cut and paste the your Entity(which you want to nullify). So it is automatically truncate the data and you will see the id start from zero.

thanks,

AKshay Deshpande.

HI, 

If you cut and paste the entity the data will cleared and the ID will start from 1.