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. |