How do delete staging tables

[Giri6]

Appreciate tips on removing the data in the staging table as well as deleting the table as needed. 

[Ankur Bawiskar]

Hi,

import set tables are cleaned up OOB by the job "Import Set Deleter"

By default, the job will delete all import sets that are older than 7 days and the associated import set table records.

Import set scheduled cleanup

Regards
Ankur

[Ankur Bawiskar]

Hi Giri,

Why do you wish to delete the staging table?

If you delete staging table.

Consider after some months user wishes to perform data load on target table using the data source.

at that time the table and the fields would be recreated again.

You can anyhow delete the records and then delete the table as mentioned by Allen

Regards
Ankur

[Allen Andreas · Accepted solution]

Hi,

If needed, you can navigate to the respective table dictionary record and utilize the "Delete all records" UI Action button to remove all the records. Once all records have been removed, you'll be able to then delete the table.

https://docs.servicenow.com/bundle/quebec-platform-administration/page/administer/table-administrati...

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/table-administratio...