SQLite - Metadata (Schema)

Sqlite Banner


SQL - Schema (Metadata)


SQLite is different from most of the database in that it stores the schema (metadata) in the sqlite_schema table as the original text of the CREATE statements that define the schema.


Select the tables

SELECT name FROM sqlite_master WHERE type='table'

Get info on a table

PRAGMA table_info(TableName)

Share this page:
Follow us:
Task Runner