Specifications

Contents
Users Guide v
Opening and previewing objects ............................................. 63
Copying, moving, and deleting objects.................................... 63
Setting the root........................................................................ 64
Moving back, forward, and up one level.................................. 65
Modifying comments ............................................................... 65
Deleting libraries...................................................................... 66
Optimizing libraries......................................................................... 67
Regenerating library entries ........................................................... 67
Rebuilding libraries.................................................................. 68
Migrating libraries .................................................................... 69
Creating a library directory report................................................... 69
PART 2 WORKING WITH DATABASES
CHAPTER 3 Managing the Database................................................................ 73
Working with database components .............................................. 73
Managing databases...................................................................... 77
Using the Database painter............................................................ 78
Modifying database preferences ............................................. 81
Logging your work ................................................................... 82
Creating and deleting a SQL Anywhere database......................... 83
Working with tables........................................................................ 84
Creating a new table from scratch........................................... 84
Creating a new table from an existing table ............................ 86
Specifying column definitions.................................................. 86
Specifying table and column properties .................................. 87
Altering a table ........................................................................ 90
Cutting, copying, and pasting columns.................................... 92
Closing a table......................................................................... 92
Dropping a table...................................................................... 93
Viewing pending SQL changes ............................................... 93
Printing the table definition...................................................... 94
Exporting table syntax............................................................. 95
About system tables................................................................ 95
Creating and editing temporary tables .................................... 96
Working with keys .......................................................................... 97
Working with indexes ................................................................... 101
Working with database views....................................................... 103
Manipulating data......................................................................... 108
Retrieving data ...................................................................... 109
Modifying data....................................................................... 109
Sorting rows .......................................................................... 110
Filtering rows ......................................................................... 112