4D v18
sql_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_name
|
sql_name |
||
An sql_name is either a standard SQL name starting with a Latin alphabet character and that contains only Latin characters, numbers and/or underscores, or a square-bracketed string. The right square bracket is escaped by doubling.
Examples:
| String to pass | sql_name |
| MySQLName_2 | MySQLName_2 |
| My non-standard !&^#%!&#% name | [My non-standard !&^#%!&#% name] |
| [already-bracketed name] | [[already-bracketed name]]] |
| name with brackets[] inside | [name with brackets []] inside] |
ALTER SCHEMA
ALTER TABLE
CREATE INDEX
CREATE SCHEMA
CREATE TABLE
DELETE
DROP INDEX
DROP SCHEMA
DROP TABLE
EXECUTE IMMEDIATE
GRANT
INSERT
LOCK TABLE
REVOKE
UNLOCK TABLE
UPDATE
Product: 4D
Theme: Syntax rules
4D SQL Reference ( 4D v18)
