What are the challenges you face when working across database platforms? Take the survey

BUG: Cannot add duplicate ViewTableSuperClass with key

I've tried to reduce this error to its simplest form...

There is a table in my database (dbo.Person) that has two computed columns. Each column uses a different user defined function to compute its value. Both functions have changed, but if I attempt to deploy the changes to both functions simultaneously, it throws the following error:

"Cannot add duplicate ViewTableSuperClass with key '[dbo].[Person]'."

At the point I select either "Deploy using SQL Compare" or "Create a deployment script"


  • Options
    RichardLRichardL Posts: 417 Gold 4
    Hi @Matthew_Sontum

    Thanks for your recent posts. 

    If you do not receive replies here you can always send us a ticket if you have a support contract with your serial key. This way a dedicated support engineer can investigate your issue for you. 

    Kind regards

    Richard Lynch. 
    Customer Support
    Redgate Software
Sign In or Register to comment.