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 |
--------|---------------|-------|------|----|--------|