Toad World® Forums

Old BUG: Table Rebuilder removes INTEGER numeric type

This has been in place for many years, not sure when it was introduced.
Toad 13.1.0.78

  1. Create a table with one or more fields using the Oracle numeric alias of INTEGER.
  2. Choose Rebuild Table
  3. The generated script replaces the INTEGER data type with NUMBER.
  4. New rebuilt table has incorrect data type.

I often need to please middleware actors that use the INTEGER alias as a keyword to trigger their own use of integer when consuming the field. So while I realize the INTEGER alias is not of much value within Oracle I would like to keep it on my tables.

I see that, thank you.