SQLite Create View Summary: in this tutorial, you will learn how to use the SQLite CREATE VIEW statement to create a new view in the database. What is a view In database theory, a view is a result set of a stored query. A view is the way to pack a query into a named…
Read more
SQLite AUTOINCREMENT Summary: in this tutorial, you will learn about SQLite AUTOINCREMENT column attribute and when to use it in your table. Introduction to SQLite ROWID table Whenever you create a table without specifying the WITHOUT ROWID option, you get an implicit auto-increment column called rowid. The rowid column store 64-bit signed integer that uniquely…
Read more
SQLite CHECK constraints Summary: in this tutorial, you will learn how to use SQLite CHECK constraint to validate data before insert or update. Introduction to SQLite CHECK constraints SQLite CHECK constraints allow you to define expressions to test values whenever they are inserted into or updated within a column. If the values do not meet…
Read more
SQLite UNIQUE Constraint Summary: in this tutorial, you will learn how to use the SQLite UNIQUE constraint to ensure all values in a column or a group of columns are unique. Introduction to SQLite UNIQUE constraint A UNIQUE constraint ensures all values in a column or a group of columns are distinct from one another…
Read more
SQLite NOT NULL Constraint Summary: in this tutorial, you will learn how to use the SQLite NOT NULL constraint to ensure the values in a column are not NULL. Introduction to SQLite NOT NULL constraint When you create a table, you can specify whether a column acceptsNULL values or not. By default, all columns in…
Read more
SQLite Primary Key Summary: in this tutorial, you will learn how to use SQLite PRIMARY KEY constraint to define a primary key for a table. Introduction to SQLite primary key A primary key is a column or group of columns used to identify the uniqueness of rows in a table. Each table has one and…
Read more
SQLite VACUUM Summary: in this tutorial, we will explain why you need to use the SQLite VACUUM command and show how to use it to optimize the database file. Why do you need SQLite VACUUM command First, when you drop database objects such as tables, views, indexes, and triggers or delete data from tables, the…
Read more
SQLite Drop Table Summary: in this tutorial, you will learn how to remove a table from the database using SQLite DROP TABLE statement. Introduction to SQLite DROP TABLE statement To remove a table in a database, you use SQLite DROP TABLE statement. The statement is simple as follows: DROP TABLE [IF EXISTS] [schema_name.]table_name; In…
Read more
SQLite Rename Column Summary: in this tutorial, you will learn step by step how to rename a column of a table in SQLite. Introduction to SQLite ALTER TABLE RENAME COLUMN statement SQLite added support for renaming column since version 3.25.0 using the ALTER TABLE statement with the following syntax: ALTER TABLE table_name RENAME COLUMN current_name…
Read more
SQLite ALTER TABLE Summary: in this tutorial, you will learn how to use SQLite ALTER TABLE statement to change the structure of an existing table. Unlike SQL-standard and other database systems, SQLite supports a very limited functionality of the ALTER TABLE statement. By using an SQLite ALTER TABLE statement, you can perform two actions: Rename…
Read more