entity names
Specifies the case for table names.
USYS$Mnemonic_PARAMS =
entity names : upper | lower
USYS$Mnemonic_PARAMS =
ents : upper | lower
Use
Applies to |
Mnemonic |
Connector Syntax |
Default |
---|---|---|---|
Microsoft SQL Server connector |
MSS |
|
|
MySQL connector |
MQL |
|
|
ODBC connector |
ODx |
|
|
PostgreSQL connector | PGS | USYS$PGS_PARAM
|
lower
|
ODBC
For the ODBC connector, and the ODBC-based connectors PGS and MSS, entity names also specifies the case for column names.
PostgreSQL
When used with PostgreSQL entity names =
upper
works when identifiers = quoted
. Without identifiers PostgreSQL
always uses lowercase.