Visual Editing (Revision #1)

The Visual Table Editor now allows users to ALTER existing table columns, such as changing the name, datatype and default value attributes.

Table Altering Limitations:

• Oracle: 8i doesn’t support renaming of columns
• DB2: DB2 only allows the ALTERing of a column datatype to VARCHAR
• Sybase: - (Sybase doesn’t support renaming columns. Sybase 11 doesn’t support renaming and changing datatypes)
• Sybase Anywhere: (Sybase Anywhere doesn’t support the ability to change a NOT NULL to NULL)
• PostgreSQL: - (PG 7.3/7.4 doesn’t support of changing datatypes. PG7.2 doesn’t support changing datatypes or NULLs)

Other vendor-specific improvements include:

• Oracle - added support for CREATE, ALTER and DROP of Clusters, Array Types and Table Types.
• MySQL - support ENUM and SET enumeration values.
• SQL Server - mark uniqueidentifier columns with the ROWGUIDCOL keyword.