Forum Discussion
Solved
Duplicate table names with different case sensitivity in data warehouse
Hi Data Warehouse let's me create two tabls with same name but with different case but then gives me error while refeshing teh schema. I have created tables [dbo].[Table_a] and [dbo].[TABLE_A] a...
Hi Jotheesh AndyDDC
Apologies for the issue you have been facing. This is a known issue. The object explorer fails to display the Fabric Data Warehouse objects (ex. tables, views, etc.) when have same noncase sensitive names. The internal team is working to fix this. Appreciate your patience.
Please refer to this link for more information: Link1
Hope this helps. Please let us know if you have any further issues.
Yes it's annoying at the moment that we can't choose a collation. I have an Idea here to upvote https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=8b35ca62-1117-ee11-a81c-000d3a01b048