SQLite Cloud: LIST TABLES

Syntax

LIST TABLES [PUBSUB]

Privileges

READWRITE

Description

The LIST TABLES command retrieves the information about the tables available inside the current database. Note that the output of this command can change depending on the privileges associated with the currently connected username. If the PUBSUB parameter is used, then the output will contain the column chname only (to have the same format as the rowset returned by the LIST CHANNELS command).

Return

A Rowset with the following columns:

schema: database schema name
name: table name
type: always 'table' in this version
ncol: number of columns
wr: without rowid flag
name: strict flag

If the PUBSUB option is used then a single chname column is returned (to produce the same output as the LIST CHANNELS command).

Example

> LIST TABLES
--------|---------------|-------|------|----|--------|
 schema | name          | type  | ncol | wr | strict |
--------|---------------|-------|------|----|--------|
 main   | Track         | table | 9    | 0  | 0      |
 main   | PlaylistTrack | table | 2    | 0  | 0      |
 main   | Playlist      | table | 2    | 0  | 0      |
 main   | Artist        | table | 2    | 0  | 0      |
 main   | Customer      | table | 13   | 0  | 0      |
 main   | Employee      | table | 15   | 0  | 0      |
 main   | Genre         | table | 2    | 0  | 0      |
 main   | Invoice       | table | 9    | 0  | 0      |
 main   | Album         | table | 3    | 0  | 0      |
 main   | InvoiceLine   | table | 5    | 0  | 0      |
 main   | MediaType     | table | 2    | 0  | 0      |
--------|---------------|-------|------|----|--------|