Specifies whether the provider distinguishes between tables and datasets with the same name but different casing.

Data Type

bool

Default Value

false

Remarks

By default, the server treats table and dataset names as case-insensitive when retrieving metadata. If multiple tables or datasets exist with the same name but different casing (for example: Customers, customers, and CUSTOMERS), only one of them is shown in system views such as sys_tables.

When this property is set to true, the server includes all case-variant tables and datasets in metadata. To prevent name collisions, the server renames duplicate entries by appending disambiguating information to their names (for example: customers becomes customers_1).

This setting affects both metadata and queries. When the server disambiguates table or dataset names in metadata, those renamed versions must also be used in SQL queries. For example, if two tables exist such as Customers and customers, you may need to query them as: "SELECT * FROM Customers" and "SELECT * FROM customers_1".

Enable this property if your environment contains tables and datasets with the same name in different casing and you need all of them represented in the metadata.