88
Views
1
Comments
Id is not starting from 0, after deleting all the records in a table.
Application Type
Reactive
Service Studio Version
11.53.25 (Build 61588)

I deleted all the records in the below table and inserted new records but the id continued from the last id of the deleted records. How can I make it start from 0? 

2016-04-22 00-29-45
Nuno Reis
 
MVP

That is an SQL issue. No matter what records you have now, those ids were used before and must be considered.

To reset it, you have to TRUNCATE the table, not DELETE FROM <Entity>.

On OutSystems, just cut and paste the entity and it will be seen as an identical new one and because it has the same name, all references will work. But the old table will remain empty on the sql server.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.