Filter
Top Products
Chapter 4. Tutorials for Adaptive Server Anywhere Users
mkdir c:\tutorial\HQ
mkdir c:\tutorial\field
3. Create the HQ database:
♦ Start Sybase Central.
♦ In the left pane, select the Adaptive Server Anywhere plug-in.
♦ In the right pane, click the Utilities tab.
♦ Double-click Create Database in the right pane.
The Create Database wizard appears.
♦ Create a database with filename
c:\tutorial\HQ.db
.
Use the default settings for this database.
An Adaptive Server Anywhere database is simply a file, which can be
copied to other locations and computers when necessary.
The next step is to add a pair of tables to the consolidated database.
❖ To add tables to the consolidated database
1. Connect to the HQ database from Sybase Central, with a user ID of DBA
and a password of SQL.
2. Select the Tables folder of the HQ database in the left pane.
3. From the File menu, choose New ➤ Table and create a table named
SalesRep using the Table Creation wizard.
4. Add the following columns to the table (you can add a column by
choosing File ➤ Add Column):
Key Column Data Type Size/Prec
Primary key Rep_key char 5
Name char 40
You do not need to use the Column property sheet.
5. Save the table by choosing File ➤ Save Table or pressing Ctrl+S.
6. From the File menu, choose New ➤ Table and create a table named
Customer with the following columns:
Key Column Data Type Size/Prec
Primary key Cust_key char 10
Name char 40
Rep_key char 5
33