Truncate to last x records

[cimm]

Is there a way to truncate the data to the last (or first) x records?

Production databases often contain more data than needed in development. Say I have an invoices table with a few 1000 records. I obviously need them in production but, to keep my development database small and fast, I probably only want to keep like 10 or so in development.

Thanks.

[cantino]

Hey @cimm! So, that would be technically easy to add, but the challenge is that you likely want to maintain referential integrity, which is difficult when truncating tables. If that doesn't matter, modifying my_obfuscate to keep a row count per table shouldn't be hard.

[cimm]

Thank you, will close this issue. I understand it's a bit more complex as I thought at first sight.