How can I delete all records from a Table?

[Rajanmehta]

Hello,

We are on Helsinki and wanted to delete all the records (> 20k) from a table. How can I do that?

please advise.

Thanks,

Rajan Mehta

[Erik Stolberg · Accepted solution]

Delete all records from a table

• Navigate to System Definition > Tables and Columns.
• Select the table for which to delete records.

Note: Some system tables do not allow this method of deleting records, for example, you cannot delete all user records [sys_user]. The list of tables does not include system tables that you cannot delete records from.

• Click Delete all records.
• In the confirmation dialog box, enter delete and click OK.
  

[Rajanmehta]

Thanks you Erik.

Exactly I was looking for.

Thank you so much.

Rajan Mehta

[Celliven]

Whilst this is correct, I think you have to ask yourself two questions;

1.Is it my production or Dev instance?

2.Do I really want to delete 20k records, as who knows the implications......

[Rajanmehta]

Chris

Thanks for your response and warning, but we were advise by HI portal to clean up all those stale records to show correct CMDB health. All those stale records are system generated and not discovery based. Support earlier tried to investigate the root cause for this system generated records, but couldn't find so we end up doing clean up.

Hope this clarifies.

Thanks,

Rajan Mehta