Forum Discussion
Helper VDuplicate table names with different case sensitivity in data warehouse
hello Don-Bot
this is a known issue. It occurs when tables with identical names but different cases (e.g., `PM_PRODUCTS` and `pm_products`) are created. While the Object Explorer does not display both tables, the system backend recognizes them as distinct, leading to conflicts during schema refreshes or other operations.
try this query
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%products%';
Super Userhello Don-Bot
this is a known issue. It occurs when tables with identical names but different cases (e.g., `PM_PRODUCTS` and `pm_products`) are created. While the Object Explorer does not display both tables, the system backend recognizes them as distinct, leading to conflicts during schema refreshes or other operations.
try this query
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%products%';
Helper VThanks nilendraFabric , that is an annoying issue