|
This tutorial uses a simple one-table database.
This section assumes you can use the UltraLite plug-in for Sybase Central to create a database.
For more information about creating a database, see Creating an UltraLite database from Sybase Central.
Create a database using the Create Database wizard for UltraLite in Sybase Central.
Create your database as follows:
Database filename c:\tutorial\ulodbc\customer.udb
Table name customer
Columns in customer table
| Column Name | Data Type (Size) | Column allows NULL values? | Default value |
|---|---|---|---|
| id | integer | No | autoincrement |
| fname | varchar(15) | No | None |
| lname | varchar(20) | No | None |
| city | varchar(20) | Yes | None |
| phone | varchar(12) | Yes | 555-1234 |
Primary key ascending id