Can I Truncate the table securitygroups_records?


Can I truncate the table securitygroups_records? will there be any impact on the application if i truncate the entire table?

Also, let me know the use of this table?


That is the information when you assign records to security groups. Deleting the entire table is like unassigning all records from their security groups. This is probably disastrous if you really use security groups.

If you need to clear rows, try first looking for rows with “deleted=1”; and then orphaned rows (pointing at other records which are themselves deleted, or non-existent).

If you search these forums for “orphaned” I think I might have left some sample queries to look for those records, I don’t remember exactly.