Unanswered: Help needed : Truncating a table based on a condition
I am writing a script and want to execute from the OS level. I have one doubt, How do I truncate the table based on some condition. Here let us assume that I want to truncate the whole table if the count(*) reaches 200,000. Please provide syntaxes for the same.