Deleting all rows using delete from data store entity

Hi,

I am trying to delete all the existing rows from the data entity using delete from data store entity smart service. Can anyone please suggest me what to include in identifiers if we want to delete everything without specifying all the identifiers?

Thanks

Yeswanth.

  Discussion posts and replies are publicly visible

Parents
  • Hi,

    Assuming that  you want to delete some test/dummy data from that table in local/Dev DB, you can use "Query Database" smart service.

    Write a SQL query and delete all the records from table. But, before executing test it thoroughly.

    Edited: For any business scenario you can use stored procedure for bulk delete as mentioned by fellow practitioners.

Reply
  • Hi,

    Assuming that  you want to delete some test/dummy data from that table in local/Dev DB, you can use "Query Database" smart service.

    Write a SQL query and delete all the records from table. But, before executing test it thoroughly.

    Edited: For any business scenario you can use stored procedure for bulk delete as mentioned by fellow practitioners.

Children
No Data