Identifiers

In the 
﻿ System, identifiers are lexical tokens that name specific entities in the database. If you want to use special characters or reserved words, then enclose them in double quotes "" to create a delimited identifier. For example, a table name is an identifier. If you enclose the table name in double quotes, then it is a delimited identifier.
The system uses identifiers to identify these objects:
Database name
Schema name
Function name
Table name
Table alias name
Column name
Column alias name
Index name
View name
Task name
Node names
Machine learning model name
Connectivity pool name
Connectivity pool participant name
Storage space name
Cluster name
Service class name
Single sign-on (SSO) protocol
Tag name
JSON key
Username
Group name
Common table expression
Subexpression name
Data pipeline name (BETA)
Data pipeline type (BETA)
Related Links
﻿SQL Syntax Conventions﻿﻿
﻿Reserved Words﻿﻿
﻿Database, Tables, Views, and Indexes﻿﻿
﻿SQL Reference﻿﻿
﻿Machine Learning Model Functions﻿﻿
﻿Connectivity Pools﻿﻿
﻿Users, Groups, and Service Classes﻿﻿

Updated 07 May 2024

Did this page help you?

SQL Syntax Conventions

Generate Tables Using sys.dummy