View the SQL statements and utility commands created by wizards   Most SQL Anywhere plug-in wizards that create a database object or run a database utility include a new page at the end of the wizard. This page displays the SQL statements and utility commands that are executed when you click Finish. Clicking Finish executes the SQL statements and/or runs the utility commands.

Alternatively, you can copy the SQL statement to the clipboard, click Cancel to exit the wizard, and then execute the SQL statements via Interactive SQL. This feature allows you to use the wizards to generate SQL scripts without modifying the database. See Viewing SQL statements and utility commands generated by wizards.

Support for spatial data   For information about the new plug-in features, including wizards, related to spatial data, see Support for spatial data.

New database Fragmentation tab   You can view a graphical representation of the fragmentation of base tables and indexes. The Fragmentation tab provides a graphical representation of the results from running sa_table_fragmentation system procedure on base tables. See The Fragmentation tab (SQL Anywhere plug-in).

Logging database changes   You can log all SQL statements executed by the SQL Anywhere plug-in that modify the database. The log is stored in a .sql file. See Database change logging.

Support for WITH NULLS NOT DISTINCT clause, CREATE INDEX statement   You can use the SQL Anywhere plug-in to, create, view, and alter indexes that use the WITH NULLS NOT DISTINCT clause. The Indexes folder contains a Nulls Distinct column. The value in the column is blank when the index is a primary key, foreign key, unique constraint, or a non-unique index.

See the UNIQUE clause of the CREATE INDEX statement.

Term breakers   The SQL Anywhere plug-in supports external term breakers and prefilters for text configuration objects. See ALTER TEXT CONFIGURATION statement.

Improvements to database documentation   When you use the Database Documentation Wizard, the generated documentation contains information about tables. The table information includes the owner name, procedures that modify the table, column information, and comments. See Documenting a database.

Improvements to the Configure Type Filter window   The Configure Type Filter window lets you specify which database objects appear in the folder list in the left pane of Sybase Central. You can set your specifications to be the default type filter. Sybase Central uses the default filter whenever it connects to a database that does not have a type filter specified. See Configuring the left pane in Sybase Central.

Improvements to Create Maintenance Plan Wizard   Maintenance plans contain user-defined operations. In the Create Maintenance Plan Wizard you can add user-defined operations as SQL statements that execute either before validation or after backup.

In addition, the Maintenance Plans folder now includes a Status column. See Maintenance plan creation.

Improvements to the Create Function Wizard   Previously, the Create Function Wizard limited the return type to a built-in type. Now, you can choose either a built-in type or a domain within the wizard. See Creating user-defined functions.

Improvements to the Backup Database Wizard   By default the Backup Database Wizard now enables free page elimination. See Making an archive backup with the Backup Database Wizard.

Overview tab enhancement   The database Overview tab shows information about the health and statistics of copy servers along with information about database mirroring. See Database health and statistics.

Improvements to the Synchronization Subscription Properties window   For databases created with SQL Anywhere 12 and later, the name of the synchronization subscription appears in the Synchronization Subscription Properties window, as well as on the Synchronization Subscriptions tab. For databases that are created with earlier versions of SQL Anywhere, the name appears as (unnamed). See Synchronization subscription creation.

New Synchronize Using Synchronization Profile window   You can synchronize a SQL Anywhere database by right-clicking a synchronization profile, clicking Synchronize, and clicking OK. See MobiLink synchronization profiles.