Use the ulcreate utility to create a database from a command prompt. With this utility, you can include utility options to configure the database.

To create a new UltraLite database (command prompt)

Run the ulcreate utility, including any necessary options. For example, to create a case-sensitive UTF-8 database called test.udb, overwriting the database if it already exists, run the following command:

ulcreate -c "DBF=test.udb" -o "case=respect;utf_encoding=1" -y

Supplying a database file in a connection string is an alternative to specifying the database file after the other options. For example:

ulcreate -o "case=respect;utf_encoding=1" -y test.udb