Create Table
Prev | Chapter 7. Features and Dialogs | Next

## Create Table

1. First - as you see in the screenshot - you can create a table with mouse and only a few keyboard typing in the "Design" tab.

2. And the second one by pure SQL statement.

Database

  A combo box with databases attached. Select one and the table will be created in this schema.

Table Name

  Name of new table. It must be given.

Columns

  Use "Add" and "Remove" buttons to create columns for this table. Every column must have a table-unique name, chosen data type (prepared combo box), optional NOT NULL constraint, and optional DEFAULT value.

  ### Important

  Consult Sqlite documentation for data type, NOT NULL, and DEFAULT handling specials, please.

Create

  Press this button to create table. The result of this operation is shown in the text area below.

Advanced (SQL) tab

  You can write full featured SQL CREATE TABLE statement here. A helper template is prepared for you. Every time you open this tab you will be asked to recreate a new SQL statement from the GUI settings in the first tab.

Prev | Up | Next
Chapter 7. Features and Dialogs | Contents | Alter Table