SQLite - Metadata (Schema)

Sqlite Banner

About

SQL - Schema (Metadata)

Storage

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.

List

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