How can we help you today? How can we help you today?

Primary Key Constraint names are being dropped when committing Temporal Tables

When I create or alter a system versioned (Temporal) table in SSMS, I define a primary key constraint name. However, when I commit the table via SQL Source Control, the name is removed:



How do I stop this from happening?
Dan
0

Comments

3 comments

Sort by
  • Eddie D
    Hi,
    Thank you for your forum post.

    Can you please confirm the version of SQL Source Control you are using?

    Many Thanks
    Eddie
    Eddie D
    0
  • DERicketts
    I am using SQL Source Control Version 7.2.35.13078 with SSMS version 18.9.2
    DERicketts
    0
  • Eddie D
    Hi,
    I have not been able to replicate the problem.

    Would it be possible to see the DDL for the Batch_Plan_Map table where you created and named the primary key constraint pk_Batch_Plan_Map?

    Many Thanks
    Eddie
    Eddie D
    0

Add comment

Please sign in to leave a comment.