SQLite Database

  1. Core SQL Concepts and Data Definition
    1. SQLite Data Types
      1. Type Affinity System
        1. TEXT Affinity
          1. NUMERIC Affinity
            1. INTEGER Affinity
              1. REAL Affinity
                1. BLOB Affinity
                2. Dynamic Typing Model
                  1. Storage Classes
                    1. NULL
                      1. INTEGER
                        1. REAL
                          1. TEXT
                            1. BLOB
                            2. Type Conversion Rules
                              1. Date and Time Handling
                                1. Date and Time Functions
                                  1. Storage Formats
                                    1. Timezone Considerations
                                  2. Creating Tables
                                    1. Basic Table Creation Syntax
                                      1. Specifying Columns and Types
                                        1. Using the IF NOT EXISTS Clause
                                          1. Temporary Tables
                                            1. Table Naming Conventions
                                            2. Table Constraints
                                              1. PRIMARY KEY Constraint
                                                1. Integer Primary Key Optimization
                                                  1. Rowid Tables
                                                    1. Composite Primary Keys
                                                    2. FOREIGN KEY Constraint
                                                      1. Enabling Foreign Key Support
                                                        1. ON DELETE Actions
                                                          1. ON UPDATE Actions
                                                            1. Referential Integrity
                                                            2. UNIQUE Constraint
                                                              1. NOT NULL Constraint
                                                                1. CHECK Constraint
                                                                  1. DEFAULT Values
                                                                    1. COLLATE Clause for Text Comparison
                                                                    2. Modifying Table Structure
                                                                      1. Renaming a Table
                                                                        1. Adding a Column
                                                                          1. Renaming a Column
                                                                            1. Dropping a Column
                                                                              1. Limitations of ALTER TABLE
                                                                                1. Workarounds for Complex Schema Changes
                                                                                2. Dropping Tables
                                                                                  1. Basic Syntax
                                                                                    1. Using the IF EXISTS Clause
                                                                                      1. Effects on Dependent Objects
                                                                                        1. Cascading Effects

                                                                                      Previous

                                                                                      2. Getting Started with SQLite

                                                                                      Go to top

                                                                                      Next

                                                                                      4. Data Manipulation Language