Reserved words in SAP Sybase IQ 16.0.
Item | Description |
---|---|
Object Names |
Unlike previous releases, reserved words in SAP Sybase IQ 16.0 cannot be used as object names, unless enclosed in brackets or double quotes. A SAP Sybase IQ 15 database could contain tables, columns, and other objects named row. In SAP Sybase IQ 16.0, row is a reserved word and cannot be used as an object name. To use a reserved word as an object name, enclose the object name
in brackets (regardless of the QUOTED_IDENTIFIER setting) or
double quotes (if QUOTED_IDENTIFIER='ON'
[default]):
// QUOTED_IDENTIFIER ON | OFF select * from [row]; alter table row2 rename [row] to col_row; // QUOTED_IDENTIFIER='ON' select "row" from row2; alter table "row" rename rownew; |
array | New reserved word in SAP Sybase IQ 16.0. |
json | New reserved word in SAP Sybase IQ 16.0. |
row | New reserved word in SAP Sybase IQ 16.0. |
rowtype | New reserved word in SAP Sybase IQ 16.0. |
unnest | New reserved word in SAP Sybase IQ 16.0. |
varray | New reserved word in SAP Sybase IQ 16.0. |