Return
-
Title
Alter Table script does not include Audit and Statistics Profile commands when rebuilding table. -
Description
Table has the following characteristics: AUDIT POLICY and STATISTICS PROFILE. When a table change requires a drop and recreate of the table the AUDIT TABLE..USING POLICY and RUNSTATS....SET PROFILE ONLY commands are not retained (i.e. generated in the change script) in the Alter Table script and so these characteristics are lost.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.