Alternative to DBCC CHECKCONSTRAINTS in SQL Azure

Is there an alternative to DBCC CHECKCONSTRAINTS on SQL Azure? For example, I can write a sproc that lists all the constraints and generates dynamic SQL to test them (eg " "). Has anyone already built something like this? select t1.* from table1 t1 left outer join table2 t2 on t2.[key] = t1.[foreign_key] where t2.[key] is null

+3


source to share


1 answer


The easiest way to resolve this is to upgrade your server to v12, where we support DBCC CHECKCONSTRAINTS.



+3


source







All Articles