Primary Key Constraint names are being dropped when committing Temporal Tables
DERicketts
Posts: 2 New member
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?
How do I stop this from happening?
Tagged:
Answers
Thank you for your forum post.
Can you please confirm the version of SQL Source Control you are using?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com