• :laugh: Good catch, Ashwin. I think the documentation needs to be expanded to list dropping the constraint as an exception to this rule. Maybe you can submit this as a documentation bug?


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/