Redgate Regex Rules
Published 17 September 2025
RX001: DROP TABLE statement
Dialects: All
Dropping a table is likely to result in the loss of data so should be investigated before continuing.
RX002: Attempt to change password
Dialects: Oracle/PostgreSQL/TSQL
Changing passwords through a DB migration is not considered best practice
RX003: TRUNCATE statement used
Dialects: All
This operation is likely to result in a loss of data so should be investigated before continuing
RX004: DROP COLUMN statement used
Dialects: All
This operation is likely to result in a loss of data so should be investigated before continuing
RX005: GRANT TO PUBLIC statement used
Dialects: All
It is not common to access to this degree so should be investigated before continuing
RX006: GRANT WITH GRANT OPTION statement used
Dialects: All
Allows grantee to grant additional permissions and so it becomes difficult to track the scope of permissions
RX007: GRANT WITH ADMIN OPTION statement used
Dialects: All
Allows grantee to grant administrative permissions and so it becomes difficult to control the scope of permissions
RX008: ALTER USER statement used
Dialects: All
Modifies the properties of an existing user and should be investigated before continuing
RX009: GRANT ALL statement used
Dialects: All
It is not common to access to this degree so should be investigated before continuing
RX010: CREATE ROLE statement used
Dialects: All
RX011: ALTER ROLE statement used
Dialects: All
This is used to modify user accounts so should be investigated before continuing
RX012: DROP PARTITION statement used
Dialects: All
RX013: CREATE TABLE statement without a PRIMARY KEY constraint
Dialects: All
RX014: No Table Description
Dialects: TSQL
A table has been created but has no MS_Description
property added
It is a good practice to include a description in the MS_Description
extended property to document the purpose of a table.