Note: If all audit policies are deleted in the audit edition page, audit will be automatically disabled
The generated audit record files will not be deleted if audit is disabled.
SELECT * FROM SYS.DATABASE_AUDIT_SPECIFICATIONS
SELECT t1.* FROM SYS.DATABASE_AUDIT_SPECIFICATION_DETAILS t1, SYS.DATABASE_AUDIT_SPECIFICATIONS t2
where t1.database_specification_id = t2.database_specification_id
and t2.name = 'xxxxxx' -- xxxxxx means the name of audit rule to be deleted
ALTER DATABASE AUDIT SPECIFICATION [Audit Name] --Audit Name is the audit name to be modified
WITH (STATE=OFF);
DROP DATABASE AUDIT SPECIFICATION [Audit Name] -- Audit Name means the name of audit rule to be deleted