You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by GitBox <gi...@apache.org> on 2021/08/02 08:02:34 UTC
[GitHub] [phoenix] richardantal edited a comment on pull request #1278: PHOENIX-5543: Implement SHOW TABLES/SCHEMAS sql commands
richardantal edited a comment on pull request #1278:
URL: https://github.com/apache/phoenix/pull/1278#issuecomment-890810753
Hey @dbwong
This is a backport PR, we already have this in the 4.x, master and 5.1 branches, 4.16 just got forgotten.
I'll try to answer your questions but I am not the original owner of the ticket.
It will list tables, views and indexes as well.
The output is the same as the output for `!tables` and `!schemas` command, here it is possible to filter those results.
```
jdbc:phoenix:localhost:65205> show tables like 'foo%';
+-----------+-------------+------------+------------+---------+-----------+---------------------------+----------------+-------------+----------------+--------------+--------------+----------------+-----------+------------+---------------+---------------------+-------------------+---------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION | INDEX_STATE | IMMUTABLE_ROWS | SALT_BUCKETS | MULTI_TENANT | VIEW_STATEMENT | VIEW_TYPE | INDEX_TYPE | TRANSACTIONAL | IS_NAMESPACE_MAPPED | GUIDE_POSTS_WIDTH | TRANSAC |
+-----------+-------------+------------+------------+---------+-----------+---------------------------+----------------+-------------+----------------+--------------+--------------+----------------+-----------+------------+---------------+---------------------+-------------------+---------+
| | | foo_ind | INDEX | | | | | ACTIVE | false | null | false | | | GLOBAL | false | false | null | |
| | | foo_1 | TABLE | | | | | | false | null | false | | | | false | false | null | |
| | | foo_view | VIEW | | | | | | false | null | false | | UPDATABLE | | false | false | null | |
+-----------+-------------+------------+------------+---------+-----------+---------------------------+----------------+-------------+----------------+--------------+--------------+----------------+-----------+------------+---------------+---------------------+-------------------+---------+
3 rows selected (0.023 seconds)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@phoenix.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org