sql_data_type

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

4D SQL Reference
- Syntax rules
- - Syntax rules
  - 4d_function_call
  - 4d_language_reference
  - all_or_any_predicate
  - arithmetic_expression
  - between_predicate
  - case_expression
  - column_definition
  - column_reference
  - command_parameter
  - comparison_predicate
  - exists_predicate
  - foreign_key_definition
  - function_call
  - in_predicate
  - is_null_predicate
  - like_predicate
  - literal
  - predicate
  - primary_key_definition
  - search_condition
  - select_item
  - sort_list
  - sql_data_type_name
  - sql_name
  - sql_string
  - subquery
  - table_constraint
  - table_reference

Home

4D v20 R7

4D SQL Reference

Syntax rules

sql_data_type_name



	ALPHA_NUMERIC \|VARCHAR \| TEXT \| TIMESTAMP \|INTERVAL \|DURATION \|BOOLEAN \|BIT \| BYTE \|INT16 \|SMALLINT \| INT32 \| INT \|INT64 \|NUMERIC \| REAL \| FLOAT \| DOUBLE PRECISION \| BLOB \| BIT VARYING \| CLOB \| PICTURE

Description

An sql_data_type_name follows the AS keyword in a 4d_function_call and can have one of the following values:

ALPHA_NUMERIC
VARCHAR
TEXT
TIMESTAMP
INTERVAL
DURATION
BOOLEAN
BIT
BYTE
INT16
SMALLINT
INT32
INT
INT64
NUMERIC
REAL
FLOAT
DOUBLE PRECISION
BLOB
BIT VARYING
CLOB
PICTURE