Hi Everyone,
Is there any code or option in the schema to disable audit trial fields to be created on a particular schema? As I know, we can disable it via option "XtkAudit_DataSchema," but this will disable for all schema. Reson to disable this in a particular schema is because this audit trial is creating four fields: @created & @lastModified (datetime), @createdBy-id & @modifiedBy-id (long) and these fields are indexed and are creating a vast database size.
Hence finding a way to disable it in the schema itself and remove these indexes from the schema.
Please let me know if you have done something similar.
I have another solution to find the index from pgSQLand use the SQL command to delete these indexes, but I don't want to use the backend for this operation hence need to find a simple solution.