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

USYS$MSS_PARAMS

lower

MySQL connector

MQL

USYS$MQL_PARAMS

upper

ODBC connector

ODx

USYS$ODx_PARAM

upper

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.

Related Topics