Notifications
Clear all

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

 

Joined: 6 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 

 


Quote
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.

 


ReplyQuote
Share: