You can use the SQL Anywhere 16 plug-in to upgrade existing databases, create new databases, and administer databases. You can choose the mode from the Mode menu or by clicking the toolbar button for the mode.
The SQL Anywhere 16 plug-in can operate in any of the following modes:
Design mode While working in Design mode, you can create and modify database objects such as tables, users, triggers, indexes, remote database servers, and so on. You can also add data to tables, create new databases, and upgrade existing databases.
For information about tasks you can perform on a SQL Anywhere database while in Design mode, see Tables, views, and indexes.
Debug mode While working in Debug mode, you can use the SQL Anywhere debugger to assist you in developing SQL stored procedures, triggers, and event handlers.
Application Profiling mode While working in Application Profiling mode, you can configure application profiling or diagnostic tracing for your database. The data that is generated helps you understand how applications interact with the database and can also help you identify and eliminate performance problems.
Comparing database schemas
Converting a database schema to match another
Viewing entity-relationship (ER) diagrams
Database health and statistics
Documenting a database
![]() |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |