Connect to the UltraLite database.

In the left pane, double-click Tables.

Double-click a table.

Click the Columns tab, right-click the white space below the table and choose New » Column.

Set the attributes for the new column.

From the File menu, choose Save Table.

Connect to the UltraLite database.

Execute a CREATE TABLE statement or ALTER TABLE, and define the columns by declaring the name, and other attributes.

The following example creates a table for a library database to hold information about borrowed books. The default value for date_borrowed indicates that the book is borrowed on the day the entry is made. The date_returned column is NULL until the book is returned.

CREATE TABLE borrowed_book (
   loaner_name CHAR(100)  PRIMARY KEY,
   date_borrowed          DATE NOT NULL DEFAULT CURRENT DATE,
   date_returned          DATE,
   book                   CHAR(20)
   );

The following example modifies the customer table to now include a column for addresses that can hold up to 50 characters:

ALTER TABLE customer
ADD address CHAR(50);