O'Reilly logo

Using SQLite by Jay A. Kreibich

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

table_info — List column information for a table

Common Usage

PRAGMA [database.]table_info( table_name );

Description

The table_info pragma is used to query information about a specific table. The result set will contain one row for each column in the table.

Column nameColumn typeMeaning
cid IntegerColumn index
name TextColumn name
type TextColumn type, as given
notnull IntegerHas a NOT NULL constraint
dflt_value TextDEFAULT value
pk IntegerIs part of the PRIMARY KEY

The default value (dflt_value) will be given as a text representation of the literal value representation. For example, a default text value includes the single quotes.

See Also

index_list

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required