showtables.sql

numeracy#TEST@DEMO_DB.(no schema)>show tables;
+-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------+
| created_on                    | name     | database_name | schema_name | kind  | comment | cluster_by | rows | bytes | owner    | retention_time |
|-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------|
| 2019-01-26 07:40:25.633 -0800 | BAR_TEST | DEMO_DB       | BAR         | TABLE |         |            |    0 |     0 | SYSADMIN | 1              |
| 2019-01-26 07:39:58.247 -0800 | TEST     | DEMO_DB       | BAR         | TABLE |         |            |    0 |     0 | SYSADMIN | 1              |
| 2019-01-26 07:40:13.771 -0800 | FOO_TEST | DEMO_DB       | FOO         | TABLE |         |            |    0 |     0 | SYSADMIN | 1              |
+-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------+
3 Row(s) produced. Time Elapsed: 0.281s
numeracy#TEST@DEMO_DB.(no schema)>show tables in schema foo;
+-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------+
| created_on                    | name     | database_name | schema_name | kind  | comment | cluster_by | rows | bytes | owner    | retention_time |
|-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------|
| 2019-01-26 07:40:13.771 -0800 | FOO_TEST | DEMO_DB       | FOO         | TABLE |         |            |    0 |     0 | SYSADMIN | 1              |
| 2019-01-26 07:39:48.153 -0800 | TEST     | DEMO_DB       | FOO         | TABLE |         |            |    0 |     0 | SYSADMIN | 1              |
+-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------+
2 Row(s) produced. Time Elapsed: 0.182s
numeracy#TEST@DEMO_DB.(no schema)>show tables in schema bar;
+-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------+
| created_on                    | name     | database_name | schema_name | kind  | comment | cluster_by | rows | bytes | owner    | retention_time |
|-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------|
| 2019-01-26 07:40:25.633 -0800 | BAR_TEST | DEMO_DB       | BAR         | TABLE |         |            |    0 |     0 | SYSADMIN | 1              |
| 2019-01-26 07:39:58.247 -0800 | TEST     | DEMO_DB       | BAR         | TABLE |         |            |    0 |     0 | SYSADMIN | 1              |
+-------------------------------+----------+---------------+-------------+-------+---------+------------+------+-------+----------+----------------+
2 Row(s) produced. Time Elapsed: 0.170s
numeracy#TEST@DEMO_DB.(no schema)>