Notifications
Clear all
Topic starter
21/08/2020 8:12 am
When I fix a dimensional modelling issue, re-generate the DLL for my star schema, copy-paste the DLL code to SSMS, i get the following error:
There is already an object named "D_Product" in the database
21/08/2020 8:33 am
So solve the problem, you have to delete an existing table before you create a new table.
Use SQL Server Management Studio, connect, select your database, move to the tables folder and delete the existing table with a right mouse click. Then, recreate the table.
Please note: if you delete a dimension table with data in a fact table, you will get an "foreign constraint" error.
Read this forum post here.