Forum Discussion
Duplicate table names with different case sensitivity in data warehouse
I am now getting a "Duplicate Table names with different case sensitivity" error in my data warehouse. However, I only see 1 table with the same name, no duplicates. And I can't rename or do anything to fix this issue. The links I've found regarding this are not helpful at all.
This is telling me "PM_PRODUCTS" is a duplicate
So where is this so called duplicate? I've hidden the table names except for the first letter so you can see that there is only one products table...
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%';
2 Replies
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%';Thanks nilendraFabric , that is an annoying issue
