VirtualTam's bookmarks

21. Pragma statements supported by SQLite

    2016-08-20
    database database/sqlite meta

    Permalink

    1# List databases
    2PRAGMA database_list;
    3
    4# Describe table
    5PRAGMA table_info(<table_name>);
    

22. SQLite Memo

    2015-03-14
    data database database/sqlite programming/sql

    Permalink

    Common ops & clauses:

    • CREATE TABLE - https://www.sqlite.org/lang_createtable.html
    • ALTER TABLE - https://www.sqlite.org/lang_altertable.html
    • UPDATE - https://www.sqlite.org/lang_update.html