SQL how to check database data validity?

Question

Is there a simple way to run a check on the databases after turning constrains back on, to check things like:

foreign keys still exist in their primary tables, primary key are unique, etc...

I am working with MS-SQL Server 2005.

SQL Server would not allow you to turn on the constraint, if the data is not valid... — Naveed Butt, Oct 05 '12 at 04:36
@Naveed: actually it does. You have to explicitly specify to recheck after they are re-enabled... — Mitch Wheat, Oct 05 '12 at 04:44
http://stackoverflow.com/questions/1098554/sql-server-how-to-make-server-check-all-its-check-constraints — Mitch Wheat, Oct 05 '12 at 04:46

score 1 · Accepted Answer · answered Jul 16 '13 at 00:35

1

Mitch Wheat linked to the correct answer.

DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS

answered Jul 16 '13 at 00:35

user802599

1 Answers1