Documentation

SQL Notebook ships with an in-app searchable help system that includes all of the documentation listed here. Press F1 inside the application to see the list of help topics.

There is extensive documentation available for SQLite, the engine that provides the foundation for SQL Notebook. Click here to view the SQLite documentation.

Control Flow

• BREAK Statement
• CONTINUE Statement
• DECLARE Statement
• ERROR_MESSAGE Function
• EXECUTE Statement
• FOR Statement
• FOREACH Statement
• IF Statement
• PRINT Statement
• RETURN Statement
• SET Statement
• THROW Statement
• TRY/CATCH Statement
• WHILE Statement

Import and Export

• Character Encodings in CSV and Text Files
• EXPORT CSV Statement
• EXPORT TXT Statement
• IMPORT CSV Statement
• IMPORT DATABASE Statement
• IMPORT TXT Statement
• IMPORT XLS Statement

File I/O

• DOWNLOAD Function
• LIST_FILES Function
• LIST_XLS_WORKSHEETS Function
• READ_CSV Function
• READ_FILE Function
• READ_FILE_TEXT Function

Text Manipulation

• ISNUMERIC Function
• Phonetic Matching Functions
• SPLIT Function
• String Distance Functions
• UUID Function
• UUID_BLOB Function
• UUID_STR Function

Math

• Algebra and Trigonometry Functions
• Cryptographic Hash Functions
• Statistical Aggregate Functions

Arrays

• ARRAY Function
• ARRAY_APPEND Function
• ARRAY_CONCAT Function
• ARRAY_COUNT Function
• ARRAY_GET Function
• ARRAY_INSERT Function
• ARRAY_MERGE Function
• ARRAY_SET Function

Dates and Times

• DATE_TRUNC Function
• DATEADD Function
• DATEDIFF Function
• DATEFROMPARTS Function
• DATENAME Function
• DATEPART Function
• DATETIMEFROMPARTS Function
• DAY Function
• EOMONTH Function
• GETDATE Function
• GETUTCDATE Function
• ISDATE Function
• MONTH Function
• NOW Function
• TO_DATE Function
• TO_DATETIME Function
• YEAR Function

Command Line Tools

• SqlNotebookCmd Command Line Tool

Notebook Operations

• CREATE SCRIPT Statement
• DROP Statement
• SAVE Statement

Other

• CHOOSE Function
• HOST_NAME Function
• NEWID Function
• USER_NAME Function

SQLite Documentation

• 35% Faster Than The Filesystem
• About SQLite
• Alphabetical List Of SQLite Documents
• ALTER TABLE
• An Asynchronous I/O Module For SQLite
• ANALYZE
• Appropriate Uses For SQLite
• Architecture of SQLite
• Atomic Commit In SQLite
• ATTACH DATABASE
• Benefits of SQLite As A File Format
• Books About SQLite
• Built-in Aggregate Functions
• Built-In Mathematical SQL Functions
• Built-In Scalar SQL Functions
• Clustered Indexes and the WITHOUT ROWID Optimization
• Code Of Conduct
• Code Of Ethics
• Command Line Shell For SQLite
• Constraint Conflict Resolution in SQLite
• CREATE INDEX
• CREATE TABLE
• CREATE TRIGGER
• CREATE VIEW
• CREATE VIRTUAL TABLE
• Database File Format
• Database Object Name Resolution
• Database Remote-Copy Tool For SQLite
• Datatypes In SQLite
• Date And Time Functions
• Defense Against The Dark Arts
• DELETE
• DETACH
• Deterministic SQL Functions
• Distinctive Features Of SQLite
• DROP INDEX
• DROP TABLE
• DROP TRIGGER
• DROP VIEW
• Dynamic Memory Allocation In SQLite
• EXPLAIN
• EXPLAIN QUERY PLAN
• Features Of SQLite
• File Format Changes in SQLite
• File Locking And Concurrency In SQLite Version 3
• Floating Point Numbers
• Full-Featured SQL
• Generated Columns
• High Reliability
• Hints for Debugging SQLite
• History Of SQLite Releases
• How SQLite Is Tested
• How SQLite Works
• How To Compile SQLite
• How To Corrupt An SQLite Database File
• How To Download Canonical SQLite Source Code
• Implementation Limits For SQLite
• Imposter Tables
• Indexes On Expressions
• In-Memory Databases
• INSERT
• Internal Versus External BLOBs
• Invalid UTF Policy
• Isolation In SQLite
• Javascript Required
• JSON Functions And Operators
• Keyword Crossreference
• List of SQLite Syntax Diagrams
• List Of Virtual Tables
• LoC Recommended Storage Format
• Long Term Support
• Maintaining Private Branches Of SQLite
• Many Small Queries Are Efficient In SQLite
• Measuring and Reducing CPU Usage in SQLite
• Memory-Mapped I/O
• Most Widely Deployed SQL Database Engine
• NUL Characters In Strings
• NULL Handling in SQLite
• Pagelink Crossreference
• Partial Indexes
• Pointer Passing Interfaces
• Powersafe Overwrite
• Pragma statements supported by SQLite
• Profiling SQL Queries
• Quality Management
• Query Language Understood by SQLite
• Query Planning
• Quirks, Caveats, and Gotchas In SQLite
• Recent SQLite News
• Recovering Data From A Corrupt SQLite Database
• REINDEX
• Release History Of SQLite
• REPLACE
• Result and Error Codes
• RETURNING
• Row Values
• Rowid Tables
• Run-Time Loadable Extensions
• Savepoints
• SELECT
• SQL Comment Syntax
• SQL Features That SQLite Does Not Implement
• SQL Language Expressions
• SQLite Archive Files
• SQLite As An Application File Format
• SQLite Autoincrement
• SQLite Backup API
• SQLite Consortium
• SQLite Consortium Agreement
• SQLite Copyright
• SQLite Copyright Release Template
• SQLite Database Speed Comparison
• SQLite Developers
• SQLite Documentation
• SQLite Download Page
• SQLite Foreign Key Support
• SQLite Frequently Asked Questions
• SQLite FTS3 and FTS4 Extensions
• SQLite FTS5 Extension
• SQLite Home Page
• SQLite In 5 Minutes Or Less
• SQLite is a Self Contained System
• SQLite Is Serverless
• SQLite Is Transactional
• SQLite Keywords
• SQLite Library Footprint
• SQLite Older News
• SQLite Over a Network, Caveats and Considerations
• SQLite Pro Support
• SQLite Requirements
• SQLite Shared-Cache Mode
• SQLite Support Options
• SQLite Unlock-Notify API
• SQLite Version 3 Overview
• SQLite: Single File Database
• SQLite's Built-in printf()
• STRICT Tables
• Swarmvtab Virtual Table
• Syntax Diagrams For SQLite
• Target Crossreference
• Temporary Files Used By SQLite
• TH3
• The Advantages Of Flexible Typing
• The Amalgamation Versus Canonical Sources
• The Base64() SQL Function
• The Base85() SQL Function
• The Bytecode() And Tables_Used() Table-Valued Functions
• The Carray() Table-Valued Function
• The Checksum VFS Shim
• The COMPLETION() Table-Valued Function
• The CSV Virtual Table
• The DBSTAT Virtual Table
• The Error And Warning Log
• The generate_series Table-Valued Function
• The Geopoly Interface To The SQLite R*Tree Module
• The INDEXED BY Clause
• The Lemon LALR(1) Parser Generator
• The Next-Generation Query Planner
• The ON CONFLICT Clause
• The Percentile Extension
• The RBU Extension
• The Schema Table
• The Session Extension
• The Spellfix1 Virtual Table
• The SQLite Amalgamation
• The SQLite Bytecode Engine
• The SQLite OS Interface or "VFS"
• The SQLite Query Optimizer Overview
• The SQLite R*Tree Module
• The SQLite Zipfile Module
• The SQLITE_DBPAGE Virtual Table
• The SQLITE_MEMSTAT Virtual Table
• The SQLITE_STMT Virtual Table
• The UINT Collating Sequence
• The UNION Virtual Table
• The Virtual Database Engine of SQLite
• The Virtual Table Mechanism Of SQLite
• The WITH Clause
• Transaction
• Uniform Resource Identifiers
• UPDATE
• UPSERT
• Using SQLite In Multi-Threaded Applications
• VACUUM
• Version Numbers in SQLite
• Vulnerabilities
• WAL-mode File Format
• Website Keyword Index
• Well-Known Users Of SQLite
• What If OpenDocument Used SQLite?
• Why Is SQLite Coded In C
• Why SQLite Does Not Use Git
• Why SQLite Uses Bytecode
• Window Functions
• Write-Ahead Logging
• Zero-Configuration