Hi everyone,
I want to clean data in database and remove identity. So i use advance sql with code
Truncate <database>
and got 1 permission error message.
Expected: how can to truncate or drop 1 database in OutSystems ODC.
Thanks !
Hi @Huy Hoang The,
Below Discussion might help you.
https://www.outsystems.com/forums/discussion/45391/truncate-tables/
https://www.outsystems.com/forums/discussion/61071/is-there-a-way-to-truncate-a-table-from-servicestudio/Thanks,Vignesh Prakash.
I think this solution is outdate with ODC studio (OutSystems ODC)
Why do you think that? Although nowhere officially documented, it looks like that in ODC like in O11 you are not will get permission to perform a TRUNCATE SQL statement.
When I need to truncate an entity, I cut and paste it in service studio. This way, a new table will be created, and OutSystems metadata will be updated to use it.
I know this. This is good trick. But i want know orther way
There is no other way.
Thank Daniel!