Skip to main content

data_type_sql

1. DATA_TYPE_SQL Function​

The DATA_TYPE_SQL function in H2 database is used to retrieve the SQL data type representation of a given expression or column.

2. Syntax​

The syntax for the DATA_TYPE_SQL function in H2 database is as follows:

DATA_TYPE_SQL(expression)

Arguments​

  • expression: The expression or column for which you want to retrieve the SQL data type representation.

Return​

  • The DATA_TYPE_SQL function returns a string that represents the SQL data type of the given expression.

3. Notes​

  • The DATA_TYPE_SQL function in H2 database provides the SQL standard data type representation. However, keep in mind that different database systems may have variations in their data type names and representations.
  • This function can be useful when you need to dynamically determine the SQL data type of an expression or column in your queries.

4. Examples​

Here are a few examples demonstrating the usage of the DATA_TYPE_SQL function in H2 database:

Example 1 - Retrieving the SQL data type of a literal value:​

SELECT DATA_TYPE_SQL(42) AS data_type;

Output:

data_type
----------------
INTEGER

Example 2 - Retrieving the SQL data type of a column:​

CREATE TABLE my_table (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  age INT
);

SELECT COLUMN_NAME, DATA_TYPE_SQL(COLUMN_NAME) AS data_type
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'my_table';

Output:

COLUMN_NAME | data_type
------------+----------------
id          | INT
name        | VARCHAR(50)
age         | INT
  • DATA_TYPE - Retrieve the Java class name of a given expression or column
  • DATA_TYPE_NAME - Retrieve the name of the Java class of a given expression or column