Release Notes
Get Started
Clusters
Cloud Settings
- AWS
- Azure
Table Type
Query Data Lakes
- Catalog
- File external table
Integration
- Authenticate to AWS resources
- Authenticate to Azure cloud storage
- BI tools
- IDE tools
  - DataGrip
  - DBeaver
- Monitor with DataDog
Query Acceleration
- CBO
- Synchronous materialized view
- Asynchronous materialized view
- Colocate join
- Indexing
  - Bitmap indexing
  - Bloomfilter indexing
- Data Deduplication
  - Use Bitmap for exact count distinct
  - Use HLL for approximate count distinct
- Lateral join
Data Loading
- Concepts
  - Strict mode
- Batch load data from Amazon S3
- Batch load data from Azure cloud storage
- Load data from a local file system
- Load data from Confluent Cloud
  - Load data from Confluent Cloud through Routine Load
  - Load data from Confluent Cloud through Kafka connector
- Load data from Amazon MSK
- Load data from Amazon Kinesis
Data Unloading
- Unload data into AWS S3
Data Backup
- Back up and restore data with AWS S3
Security
- Console Access Control
- Data Access Control
- Application keys
- Service accounts
- Use SSL connection
Alarm
Usage and Billing
- Understand your usage
- Understand your billing
Organizations and Accounts
Reference
- Amazon Web Services (AWS)
- Microsoft Azure
- SQL Reference
- SQL Functions
  - Function list
  - Java UDFs
  - Window functions
  - Lambda expression
  - Date Functions
    - add_months
    - adddate
    - convert_tz
    - current_date
    - current_time
    - current_timestamp
    - date
    - date_add
    - date_diff
    - date_format
    - date_slice
    - date_sub, subdate
    - date_trunc
    - datediff
    - day
    - dayofweek_iso
    - dayname
    - dayofmonth
    - dayofweek
    - dayofyear
    - days_add
    - days_diff
    - days_sub
    - from_days
    - from_unixtime
    - hour
    - hours_add
    - hours_diff
    - hours_sub
    - jodatime_format
    - last_day
    - makedate
    - microseconds_add
    - microseconds_sub
    - minute
    - minutes_add
    - minutes_diff
    - minutes_sub
    - month
    - monthname
    - months_add
    - months_diff
    - months_sub
    - next_day
    - now
    - previous_day
    - quarter
    - second
    - seconds_add
    - seconds_diff
    - seconds_sub
    - str_to_date
    - str_to_jodatime
    - str2date
    - time_slice
    - time_to_sec
    - timediff
    - timestamp
    - timestampadd
    - timestampdiff
    - to_date
    - to_days
    - to_iso8601
    - to_tera_date
    - to_tera_timestamp
    - unix_timestamp
    - utc_timestamp
    - week
    - week_iso
    - weekofyear
    - weeks_add
    - weeks_diff
    - weeks_sub
    - year
    - years_add
    - years_diff
    - years_sub
  - Aggregate Functions
    - any_value
    - approx_count_distinct
    - array_agg
    - avg
    - bitmap
    - bitmap_agg
    - count
    - count_if
    - corr
    - covar_pop
    - covar_samp
    - group_concat
    - grouping
    - grouping_id
    - hll_empty
    - hll_hash
    - hll_raw_agg
    - hll_union
    - hll_union_agg
    - max
    - max_by
    - min
    - min_by
    - multi_distinct_sum
    - multi_distinct_count
    - percentile_approx
    - percentile_cont
    - percentile_disc
    - retention
    - stddev
    - stddev_samp
    - sum
    - variance, variance_pop, var_pop
    - var_samp
    - window_funnel
  - Geographic Functions
    - st_astext
    - st_circle
    - st_contains
    - st_distance_sphere
    - st_geometryfromtext
    - st_linefromtext
    - st_point
    - st_polygon
    - st_x
    - st_y
  - String Functions
    - append_trailing_char_if_absent
    - ascii
    - char
    - char_length
    - character_length
    - concat
    - concat_ws
    - ends_with
    - find_in_set
    - group_concat
    - hex
    - hex_decode_binary
    - hex_decode_string
    - instr
    - lcase
    - left
    - length
    - locate
    - lower
    - lpad
    - ltrim
    - money_format
    - null_or_empty
    - parse_url
    - repeat
    - replace
    - reverse
    - right
    - rpad
    - rtrim
    - space
    - split
    - split_part
    - substring_index
    - starts_with
    - strleft
    - strright
    - str_to_map
    - substring
    - trim
    - ucase
    - unhex
    - upper
    - url_decode
    - url_encode
  - Pattern Matching Functions
    - like
    - regexp
    - regexp_extract
    - regexp_extract_all
    - regexp_replace
  - JSON Functions
    - Overview of JSON functions and operators
    - JSON operators
    - JSON constructor functions
    - JSON query and processing functions
  - Bit Functions
    - bitand
    - bitnot
    - bitor
    - bitxor
    - bit_shift_left
    - bit_shift_right
    - bit_shift_right_logical
  - Bitmap Functions
    - bitmap_and
    - bitmap_or
    - bitmap_andnot
    - bitmap_xor
    - bitmap_contains
    - bitmap_empty
    - bitmap_has_any
    - bitmap_hash
    - bitmap_intersect
    - bitmap_max
    - bitmap_min
    - bitmap_union
    - bitmap_union_count
    - bitmap_remove
    - bitmap_to_array
    - bitmap_from_string
    - bitmap_to_string
    - to_bitmap
    - base64_to_bitmap
  - Array Functions
    - all_match
    - any_match
    - array_agg
    - array_append
    - array_avg
    - array_concat
    - array_contains
    - array_contains_all
    - array_cum_sum
    - array_difference
    - array_distinct
    - array_filter
    - array_generate
    - array_intersect
    - array_join
    - array_length
    - array_map
    - array_max
    - array_min
    - array_position
    - array_remove
    - array_slice
    - array_sort
    - array_sortby
    - array_sum
    - arrays_overlap
    - array_to_bitmap
    - cardinality
    - element_at
    - reverse
    - unnest
  - Map Functions
    - cardinality
    - distinct_map_keys
    - element_at
    - map_apply
    - map_concat
    - map_filter
    - map_from_arrays
    - map_keys
    - map_size
    - map_values
    - transform_keys
    - transform_values
  - Binary Functions
    - to_binary
    - from_binary
  - cast function
  - hash function
  - Cryptographic Functions
    - aes_encrypt
    - aes_decrypt
    - base64_decode_binary
    - base64_decode_string
    - from_base64
    - md5
    - md5sum
    - md5sum_numeric
    - sha2
    - sm3
    - to_base64
  - Math Functions
    - abs
    - acos
    - asin
    - atan
    - atan2
    - bin
    - ceil
    - ceiling
    - conv
    - cos
    - cosh
    - cosine_similarity
    - cosine_similarity_norm
    - cot
    - degrees
    - divide
    - e
    - exp
    - floor
    - fmod
    - greatest
    - least
    - ln
    - log
    - log2
    - log10
    - mod
    - multiply
    - negative
    - pi
    - pmod
    - positive
    - pow
    - radians
    - rand
    - round
    - sign
    - sin
    - sinh
    - sqrt
    - square
    - tan
    - tanh
    - truncate
  - Pattern Matching Functions
    - like
    - regexp
    - regexp_extract
    - regexp_extract_all
    - regexp_replace
  - Percentile Functions
    - percentile_approx_raw
    - percentile_empty
    - percentile_hash
    - percentile_union
  - Scalar Functions
    - hll_cardinality
  - Struct Functions
    - named_struct
    - row
  - Table Functions
    - files
    - generate_series
    - json_each
    - unnest
  - Utility Functions
    - catalog
    - current_role
    - current_version
    - database
    - host_name
    - isnull
    - isnotnull
    - last_query_id
    - sleep
    - uuid
    - uuid_numeric
    - version
- AUTO_INCREMENT
- Generated columns
- System variables
- System limits
- Information Schema
- System Metadatabase
API
- Overview
- Actions
  - Clusters
    - Create and Manage Clusters
    - Query Clusters
      - List clusters
      - Query status of a cluster
  - Identity and Access Management
    - Tokens
      - Create access token
    - Members and roles
  - Organization and Account
    - Get account list
  - Usage and Billing
Terraform Provider
- Introduction
- Deployment on AWS
- Deployment on Azure
Run scripts

SHOW TABLES

Description

This statement is used to display all tables in the current db

Syntax：

SHOW TABLES;

Parameters

Parameter	Required	Description
catalog_name	No	The name of the internal catalog or an external catalog. If you do not specify this parameter or set it to `default_catalog`, tables in CelerData databases are returned. If you set this parameter to the name of an external catalog, tables in databases of an external data source are returned. You can run SHOW CATALOGS to view internal and external catalogs.
db_name	No	The database name. If not specified, the current database is used by default.

Examples

Example 1: View tables in database example_db of the default_catalog after connecting to the CelerData cloud account. The following two statements are equivalent.

show tables from example_db;
+----------------------------+
| Tables_in_example_db       |
+----------------------------+
| depts                      |
| depts_par                  |
| emps                       |
| emps2                      |
+----------------------------+

show tables from default_catalog.example_db;
+----------------------------+
| Tables_in_example_db       |
+----------------------------+
| depts                      |
| depts_par                  |
| emps                       |
| emps2                      |
+----------------------------+

Example 2: View tables in the current database example_db after connecting to this database.

show tables;
+----------------------------+
| Tables_in_example_db       |
+----------------------------+
| depts                      |
| depts_par                  |
| emps                       |
| emps2                      |
+----------------------------+

Example 2: View tables in database hudi_db of the external catalog hudi_catalog.

show tables from hudi_catalog.hudi_db;
+----------------------------+
| Tables_in_hudi_db          |
+----------------------------+
| hudi_sync_mor              |
| hudi_table1                |
+----------------------------+

Alternatively, you can run SET CATALOG to switch to the external catalog hudi_catalog and then run SHOW TABLES FROM hudi_db;.

References

SHOW CATALOGS: Views all catalogs in a CelerData cloud account.
SHOW DATABASES: Views all databases in the internal catalog or an external catalog.
SET CATALOG: Switches between catalogs.

In this article

SHOW TABLES