SQLite Database

3.

Core SQL Concepts and Data Definition

3.1.

SQLite Data Types

3.1.1.

Type Affinity System

3.1.1.1.

3.1.1.2.

NUMERIC Affinity

3.1.1.3.

INTEGER Affinity

3.1.1.4.

3.1.1.5.

3.1.2.

Dynamic Typing Model

3.1.3.

Storage Classes

3.1.3.1.

3.1.3.2.

3.1.3.3.

3.1.3.4.

3.1.3.5.

3.1.4.

Type Conversion Rules

3.1.5.

Date and Time Handling

3.1.5.1.

Date and Time Functions

3.1.5.2.

Storage Formats

3.1.5.3.

Timezone Considerations

3.2.

Creating Tables

3.2.1.

Basic Table Creation Syntax

3.2.2.

Specifying Columns and Types

3.2.3.

Using the IF NOT EXISTS Clause

3.2.4.

Temporary Tables

3.2.5.

Table Naming Conventions

3.3.

Table Constraints

3.3.1.

PRIMARY KEY Constraint

3.3.1.1.

Integer Primary Key Optimization

3.3.1.2.

3.3.1.3.

Composite Primary Keys

3.3.2.

FOREIGN KEY Constraint

3.3.2.1.

Enabling Foreign Key Support

3.3.2.2.

ON DELETE Actions

3.3.2.3.

ON UPDATE Actions

3.3.2.4.

Referential Integrity

3.3.3.

UNIQUE Constraint

3.3.4.

NOT NULL Constraint

3.3.5.

CHECK Constraint

3.3.6.

3.3.7.

COLLATE Clause for Text Comparison

3.4.

Modifying Table Structure

3.4.1.

Renaming a Table

3.4.2.

Adding a Column

3.4.3.

Renaming a Column

3.4.4.

Dropping a Column

3.4.5.

Limitations of ALTER TABLE

3.4.6.

Workarounds for Complex Schema Changes

3.5.

Dropping Tables

3.5.1.

3.5.2.

Using the IF EXISTS Clause

3.5.3.

Effects on Dependent Objects

3.5.4.

Cascading Effects

Previous

2. Getting Started with SQLite

Go to top

Next

4. Data Manipulation Language