Visual Editing Enhancements

Database Schema Objects are even easier to modify in Aqua Data Studio 7.5 with the addition of Renaming and Support for Valid/Invalid Indexes (Oracle) in Index Properties Menu. The Table Visual Editor has been enhanced to include renaming of all DDL options in one convenient interface.

Renaming Objects	Oracle Index

Visual renaming for schema objects includes the following object types in the corresponding databases:

• 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+