tree
Scott C Gray edited this page Feb 26, 2017
·
1 revision
Shows a tree view of all the tables
\tree [--table-pattern=pat] [--schema-pattern=pat]
A tree view of all tables.
A SQL pattern to be used to filter the set of object names that are displayed.
A SQL pattern to be used to filter the set of object schema names that are displayed. For most databases, the "schema name" refers to the name of the owner of the object.
This can be used to restrict the types of objects that are displayed. If type is not provided, then all object types are returned. Available types are:
| Type | Description |
|---|---|
| user | Displays only user-created tables |
| system | Displays only system tables |
| view | Displays only views |
| alias | Displays only aliases |
| synonym | Displays only synonyms |