SQL Keywords KeywordDescription ADDAdds a column in an existing table ADD CONSTRAINTAdds a constraint after a table is already created ALLReturns true if all of the subquery values meet the condition ALTERAdds,
Non-reserved keywords have special meanings only in a specific environment and can be used as identifiers in other environments. Table 1 SQL keywords Keyword SQL:1999 SQL-92 ABORT Non-reserved - - ABS - Non-reserved - ABSOLUTE Non-reserved Reserved Reserved ACCESS Non-reserved - - ACCOUNT ...
If the application called SQLDriverConnect or SQLBrowseConnect, this is the value of the DSN keyword in the connection string passed to the driver. If the connection string did not contain the DSN keyword (such as when it contains the DRIVER keyword), this is an empty string. SQL_DATA_...
Keywords are words that have significance in SQL. Certain keywords, such asSELECT,DELETE, orBIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. ...
ISqlKeywordDictionary ISQLPrivilege ISQLSyntax ISQLSyntax2 ISQLSyntax3 ISqlWorkspace ISqlWorkspace2 ISquareEdgesLayout IStatisticDescription IStatisticDescription2 IStatisticDescriptions IStatisticsRequest IStatisticsRequest2 IStringDomain ISubcircuit ISubtypes ISurface ISurfaceIntersectionEvents ISynchronizationHe...
The management client has the following basic commands. In the listing that follows,node_iddenotes either a data node ID or the keywordALL, which indicates that the command should be applied to all of the cluster's data nodes. CONNECTconnection-string ...
Keyword Data Types Constant and Macro Functions and Operators Expressions Type Conversion Full Text Search System Operation Transaction Management DDL Syntax DDL Syntax Overview ALTER DATABASE ALTER FOREIGN TABLE (GDS Import and Export) ALTER FOREIGN TABLE (for HDFS or OBS) ALTER FOREIGN TABLE (SQL ...
To specify a field in an SQL expression, provide a delimiter if the field name would otherwise be ambiguous, such as if it were the same as an SQL reserved keyword. Since there are many reserved keywords, and new ones can be added in subsequent releases, a good practice...
The partially-ordered expression must be present in the select list of the query with the alias ROWTIME. The leading expression of the ORDER BY clause must not contain the ROWTIME function and must not use the DESC keyword. The ROWTIME column...
If you need to emulate filtering used by a custom manager, or want to perform one-off custom filtering, both methods also accept optional keyword arguments, which should be in the format described in Field lookups. Note that in the case of identical date values, these methods will use the ...