4D v14
sql_data_type_name
- 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
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 |
||
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
Product: 4D
Theme: Syntax rules
4d_function_call
Principles for integrating 4D and the 4D SQL engine
4D SQL Reference ( 4D v11 SQL Release 4 )
4D SQL Reference ( 4D v14)
4D SQL Reference ( 4D v12.1)
4D SQL Reference ( 4D v13.4)
4D SQL Reference ( 4D v14 R2)
4D SQL Reference ( 4D v14 R3)
4D SQL Reference ( 4D v14 R4)
