Do the tables have some sort of ID (like an identity)?
If they do, you could write a delete statement using a modulo operator that keeps only 1/5th of the rows for example.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP