SQLite Editor

Column management


Creating columns

On Table view tap "Add Column" button, Column view will pop.

Type a name for the new column.

Set type of the column. If you wold like to set a custom type then type it in "Custom type" field.

Define column as primary key if it's needed. Each table can have one primary key.

Define column as auto-incremented if it's needed. Only columns defined as primary key can be defined as auto-incremented.

Be careful,none of fields of a saved column can not be changed.

Finally tap "Save" button.

Deleting columns

On Table view tap on "Edit" button, then select columns you want to delete, finally tap on "Done" button. If containing table is already saved you can't delete or edit it's columns.