Columns
note
SQLite supports a limited subset of ALTER TABLE commands. In SQLite, you can rename a table, rename a column within a table, and add a new column to an existing table. For more information about ALTER TABLE in SQLite, refer to the official SQLite documentation.
To delete a column in SQLite, right-click a table and select Modify Table. In the Modify dialog, select the column that you want to delete and click the Remove button (
). The Modify action recreates a table without the deleted column.
To hide a column, right-click the corresponding header cell and select Hide column.
Alternatively, you can right-click any of the cells in the header row and select Columns List Alt0\. In the Columns List window, select a column name and press Space. You can hide all columns. To search through the column list, just start typing a column name in the Columns List window.
Select the hidden column (a strikethrough column name) and press Space.
tip
You can review the whole table structure in the Structure tool window (). The Structure tool window displays all columns.
Click the settings icon (
) and select Reset View. As a result, the data becomes unsorted, the columns appear in the order they were defined initially, and all the columns are shown.
You can assign HTML, CSS, XML, RegExp, or any other formal language for the whole column. So, when you have a piece of code inside the cell that belongs to the column, you can use code generation, code completion, and other IDE features.
To inject a language for the whole column, right-click the corresponding header cell, and select Set Highlighting Language. In the list of supported languages, select the language that you want to inject.
In the Database tool window ( ) , select any database objects and drag them to your code.
