Specifications

Working with tables
84 InfoMaker
❖ To delete a local SQL Anywhere database:
1 Open the Database painter.
2 From the Objects view, launch the Delete ASA Database utility included
with the ODBC interface.
The Delete Local Database dialog box displays.
3 Select the database you want to delete and select Open.
4 Click Yes to delete the database.
When you click Yes, InfoMaker deletes the specified database.
Working with tables
When you open the Database painter, the Object view lists all tables in the
current database that you have access to (including tables that were not created
using InfoMaker). You can create a new table or alter an existing table. You can
also modify table properties and work with indexes and keys.
Creating a new table from scratch
In InfoMaker, you can create a new table in any database to which InfoMaker
is connected.
❖ To create a table in the current database:
1 Do one of the following:
• Click the Create Table button.
• Right-click in the Columns view and select New Table from the pop-
up menu.
• Right-click Tables in the Objects view and select New Table from the
pop-up menu.
• Select Insert>Table from the Object menu.
The new table template displays in the Columns view. What you see in the
view is DBMS-dependent. You use this template to specify each column
in the table. The insertion point is in the Column Name box for the first
column.