I use one of the tables in my database as a log of user transactions.
I don't want table growing indefinitely large, so I was wondering if I can prespecify a way keeping the table fixed at say 100 rows. In other words, once the table is filled with the a 100 rows, the next inserted row will replace the 1st row that was inserted into the table...and so on.
If this is not possible, I imagine I could write an sql script which could run, say weekly, and remove all rows from this table, except the most recent 100. What is the best way for me to do this?
Thanks,
--Norm
I don't want table growing indefinitely large, so I was wondering if I can prespecify a way keeping the table fixed at say 100 rows. In other words, once the table is filled with the a 100 rows, the next inserted row will replace the 1st row that was inserted into the table...and so on.
If this is not possible, I imagine I could write an sql script which could run, say weekly, and remove all rows from this table, except the most recent 100. What is the best way for me to do this?
Thanks,
--Norm