Request for a new Code Analysis Rule: table names should be under 26 characters (4270637)

RESOLUTION

1. Go to View | Toad options | Code Analysis |General and, on the right panel select Edit Rules
2. Click on Create New Rule
3. Enter the Description, the tip and the XPath Expression provided below:
   //CREATE/TABLE/QNAME
   [IDENTIFIER/string-length(@value) >= 26]

See if this rule works.

If we create the  table below:

CREATE TABLE za_testRulesTableNameLooooooooooooooooooooooooooooong
(
    col1    NUMBER,
    col2    NUMBER
)

We get this:

Once we short the name of the table, rule 7001 should disappear:

STATUS

This rule has been added in Toad for Oracle 13.0 as Rule 2142 ("Table names should be under N characters.") .The latest version of Toad for Oracle can be downloaded here

You can create rules in the 7000 - 9999 range. This range is reserved for customer usage, and Quest will never write or overwrite anything there.