AutoIt3 (Extras SQLite)
Small. Fast. Reliable.
Choose any three.


SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.


Ongoing development and maintenance of SQLite is sponsored in part by SQLite Consortium members, including:

Current Status

  • Version 3.7.2 of SQLite is recommended for all new development. Upgrading from all prior SQLite versions is recommended.

Common Links

Table of Content:


                    SQLite Version 3


          SQLite Syntax Help

                    aggregate functions

                    ALTER Table


                    ATTACH Database

                    BEGIN Transaction


                    COMMIT Transaction

                    core functions

                    CREATE Index

                    CREATE Table

                    CREATE Trigger

                    CREATE View

                    CREATE Virtual Table

                    date and time functions


                    DETACH Database

                    DROP Index

                    DROP Table

                    DROP Trigger

                    DROP View

                    END Transaction



                    INDEXED BY



                    ON CONFLICT Clause




                    ROLLBACK Transaction

                    SAVEPOINT, RELEASE




                    Atomic Commit

                    Command Line Tool

                    Data Types

                    Distinctive Features

                    Null Handling

                    File Locking

                    Not Supported Features

                    Query Optimizing

                    Shared Cache Mode

                    Syntax diagrams