SHOW TYPECAST
Description
View all type cast under the database. If the user specifies a database, then view the corresponding database, otherwise directly query the database where the current session is located
Syntax
SHOW TYPE_CAST [ { IN | FROM } <db>]Required Parameters
1. <db>
The name of the database to query.
Return Value
| Column Name | Description |
|---|---|
| Origin Type | Original Type |
| Cast Type | Conversion Type |
Access Control Requirements
The user executing this SQL command must have at least the following privileges:
| Privilege | Object | Notes |
|---|---|---|
Select_priv | Database (DB) | The user or role must have Select_priv on the DB to view all type conversions under the database |
Usage Notes
If a database is specified by the user, the system will query the specified database; otherwise, it will query the database associated with the current session by default.
Example
-
View all type casts in database TESTDB
SHOW TYPE_CAST IN TESTDB;+----------------+----------------+ | Origin Type | Cast Type | +----------------+----------------+ | DATETIMEV2 | BOOLEAN | | DATETIMEV2 | TINYINT | | DATETIMEV2 | SMALLINT | | DATETIMEV2 | INT | | DATETIMEV2 | BIGINT | | DATETIMEV2 | LARGEINT | | DATETIMEV2 | FLOAT | | DATETIMEV2 | DOUBLE | | DATETIMEV2 | DATE | | DATETIMEV2 | DATETIME | | DATETIMEV2 | DATEV2 | | DATETIMEV2 | DATETIMEV2 | | DATETIMEV2 | DECIMALV2 | | DATETIMEV2 | DECIMAL32 | | DATETIMEV2 | DECIMAL64 | | DATETIMEV2 | DECIMAL128 | | DATETIMEV2 | DECIMAL256 | | DATETIMEV2 | VARCHAR | | DATETIMEV2 | STRING | | DECIMAL256 | DECIMAL128 | | DECIMAL256 | DECIMAL256 | | DECIMAL256 | VARCHAR | | DECIMAL256 | STRING | +----------------+----------------+