How long do records additionally created when dropping an archive table?

[LonLandry1]

Howdy Community,

How long do records created on the tables below stay in the system?

(I am not worried about records on tables beginning with ar_)

• Deleted File Related table - what was deleted)
• Deleted File References table - what columns (reference to) were deleted
• Deleted Application Files table - additional files related to dropped table

Are records on the above tables auto cleaned over time by the system?

Thanks for your help & time.

[Shivalika · Accepted solution]

Hello @LonLandry1 

I don't think one exists. You need to create a Table Cleaner Rule to cleanup this table time to time. Same is for logs table also, if these keep accumulating there will be performance issues. So, better do cleanup. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[LonLandry1]

Thanks, I knew I had to eventually learn how to use Table Cleaner Rules.

[Shivalika]

Yess, @LonLandry1 have been there, we also receive servicenow alerts for database cleanup because it's impacting performance. 

So archival rules for general table and cleanup rule for this log type tables are very important to keep your instance burden free. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY