Clear all

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


Joined: 2 years ago
Posts: 2
Topic starter  

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: 9 years ago
Posts: 17

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.