Category: SQLite

SQLite views are logical representations of tables that can be used to query data in the database. Views can be created from one or more tables, and they can be used to query data in the database just like regular tables. Views are often used to simplify complex queries, or to hide sensitive data from…(Continue Reading)

SQLite is a relational database management system (RDBMS), which means that it uses a transaction-based model to ensure data consistency. Any SQL command (select, insert, update, delete, create, drop, …) that accesses the SQLite database (except for a few PRAGMA statements) will automatically start a TRANSACTION. Automatically started transactions are committed when the last SQL…(Continue Reading)

In this article you will learn how to modify the structure of a table. SQLite supports a number of ways to modify the structure and contents of tables. The most common cases are those where you have to change the name of a table, add new columns or constraints to a table. The SQLite ALTER…(Continue Reading)

In this article we will show how to drop an existing column in a table created in the SQLite database. The SQLite DROP COLUMN keyword drops an existing column from an SQLite table. To drop a column, use the ALTER TABLE command followed by the DROP COLUMN keyword. To understand better, follow the DROP COLUMN…(Continue Reading)

In this article we will show how to RENAME an existing column in a table created in the SQLite database. The SQLite RENAME COLUMN TO keyword changes the name of the existing column with a new name. To rename a column, use the ALTER TABLE command followed by the RENAME COLUMN TO keyword. To better…(Continue Reading)

In this article we will show how to add a new column or multiple new columns to an existing table in the SQLite database. The SQLite ADD COLUMN keyword is used to add a new column to an existing table. The new column is always appended to the end of the existing column list. When…(Continue Reading)