Creating databases

An UltraLite database can be created using any of the following methods:

Using Sybase Central, a database can be interactively created with appropriate definitions for the desired tables and other schema-related items.

The ulcreate utility creates an empty database that does not have any tables defined. Applications that create a database by calling ULCreateDatabase need to also execute SQL CREATE statements to create tables and index definitions.

Name the database explicitly

Different interfaces may use different default file names for the database. If you are mixing the interfaces, it is best to always explicitly name the database when creating or connecting. You can do this using the DBN= connection parameter. See UltraLite DBN connection parameter.