Skip to content

How to delete all the records in a table without writing a background script.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #7391
    Zak Cole
    Participant

    If there is a table that you want to delete all the records, but don’t want to spend the time to write a background script, look no further.
    Navigate to system Definition > tables.
    Click on the search icon if there is no search bar and a search field will appear.
    Under the field label, type in the table name that you are targeting.
    For example, if you want to target the incident table type in ‘incident.’
    Let’s say we want to delete everything in the Perspectium logs, type in PSP Log Message.
    Next look at the name field to ensure that this is the right table name.
    In this example the table name is correct, u_psp_log message.
    image1
    Once inside the table, look at the top right corner and locate the ‘Delete All Records’ button.
    image3
    After clicking on the button, a confirmation window will appear.
    image3
    Type in ‘delete’ and once you press OK every single record in that table will be deleted.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.