Sybase DC38133-01-0902-01 manual To add tables to the consolidated database

Chapter 4. Tutorials for Adaptive Server Anywhere Users

mkdir c:ntutorialnHQ

mkdir c:ntutorialnfield

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