Clear all

[Solved] There is already an object named "D_Product" in the database  


Joined: 4 months ago
Posts: 2
21/08/2020 9: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 


Joined: 7 years ago
Posts: 5
21/08/2020 9: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.