Users Guide
Working with Databases

Table of Contents

Working with database components

Managing databases

Using the Database painter

Modifying database preferences

Logging your work

Creating and deleting a SQL Anywhere database

Working with tables

Creating a new table from scratch

Creating a new table from an existing table

Specifying column definitions

Specifying table and column properties

Altering a table

Cutting, copying, and pasting columns

Closing a table

Dropping a table

Viewing pending SQL changes

Printing the table definition

Exporting table syntax

About system tables

Creating and editing temporary tables

Working with keys

Working with indexes

Working with database views

Manipulating data

Retrieving data

Modifying data

Sorting rows

Filtering rows

Viewing row information

Importing data

Printing data

Saving data

Creating and executing SQL statements

Building and executing SQL statements

Customizing the editor

Controlling access to the current database