Hi all: when we originally created our tables we didn’t bother with the option to delete all records older than xyz. As an experiment to understand how this option works, I created a test table to log some data, and had f-sql delete all records older than 30 days. I was expecting to see a trigger be created, but I don’t see anything different about this new test table. What happens when this option is enabled? thx. D. Lewis
When that group runs, FactorySQL will automatically delete rows in that historical log table whose timestamp is more than 30 days old. It creates a sort of “circular log”.
so, where is that delete statement executed from? Is it encapsulated within factory sql and not in the sql server database at all?