The (columns), AS query, and EDIT SQL tabs allow you to create a table in various ways.
A combo box with databases attached. Select one and the table will be created in this schema.
Name of new table. It must be nonempty.
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 extra constraint (nothing, NOT NULL, PRIMARY KEY [implies NOT NULL], or AUTOINCREMENT [implies PRIMARY KEY and NOT NULL]), and optional DEFAULT value. If you want to use your own non-standard data type, you can type it into the combo box. Default values must be supplied as they would be in a CREATE TABLE statement: expressions must be enclosed in (), text literals which don't look like identifiers or which match reserved words must be quoted. Numbers do not need to be quoted, and will be treated as text literals if they are.
Consult Sqlite documentation for data type, NOT NULL, and DEFAULT handling specials, please.
This opens the query builder where you can create a table using a CREATE TABLE name AS SELECT ... statement.
You can write any SQL CREATE TABLE statement here: the first line containing 'CREATE TABLE "schemaname"."tablename" [AS or (]' is not editable except by changing the Database name or Table Name in the fields above. When you first open this tab, it will make a CREATE TABLE statement from the information in the previously open (columns) or AS query tab. Every subsequent time you open this tab you will be asked if you want to keep the existing SQL or make it from the information in the previously open tab again.
If you omit the terminating semicolon, sqliteman will add it for you.
Check this box to create a WITHOUT ROWID table. It must have at least one PRIMARY KEY and no AUTOINCREMENT.
Press this button to create the table. When the (columns) tab is selected, the Create button is only enabled when the new table name is nonempty, and all column names are different, and if there is an AUTOINCREMENT column its type is INTEGER and no other column is a PRIMARY KEY, and if Without rowid is checked there is at least one PRIMARY KEY column. When the AS query tab or the Edit SQL tab is selected, the Create button is only enabled if the new table has a nonempty name. The result of this operation is shown in the text area below, which will expand if it needs to contain a long error message.
Sqlite will permit a table to be created with a table name which contains non-alphanumeric characters or with an empty string as a column name, so sqliteman allows these. However in both of these cases it asks if you really want to do it, since the underlying library doesn't display such tables correctly.