Visual Editing Enhancements (Revision #13)

Database Schema Objects are even easier to manipulate in Aqua Data Studio 7.5 with the addition of Renaming Feature, Support for new DDL Syntax (SQL Server 2005 and 2008) and Support for Valid/Invalid Indexes (Oracle). The Table Visual Editor has been redesigned to include renaming of all DDL options in one convenient interface

Renaming Objects	DDL Syntax	Oracle Index

- Visual Editing now supports the renaming of schema objects

- Scripting for SQL Server 2005 and 2008 now support new DDL Syntax.

Oracle -- Index properties now displays VALID / UNUSABLE

Visually rename for schema objects is summarized in the table below:

* Database
    Informix
    MySQL 6.0+
    SQL Server 2000+
    Sybase ASE

* Table
    Apache Derby
    DB2
    Informix
    MySQL
    Oracle
    PostgreSQL
    SQL Server
    Sybase Anywhere
    Sybase IQ
    Sybase ASE

* Index
    Apache Derby
    DB2
    Informix
    Oracle
    PostgreSQL
    SQL Server
    Sybase Anywhere
    Sybase IQ

* View
    Oracle
    PostgreSQL 8.3+
    SQL Server
    Sybase ASE

* Trigger
    Oracle 9+
    PostgreSQL
    SQL Server
    Sybase ASE

* Stored Procedure
    SQL Server
    Sybase ASE

* Function
    PostgreSQL
    SQL Server 2000+

* Data Type
    SQL Server
    Sybase Anywhere 9+
    Sybase IQ 12.6+

* Default
    Sybase ASE

* Rule
    Sybase ASE

* Sequence
    Informix 10+
    Oracle

* Synonym
    Oracle

* User
    SQL Server 2005+