How will you activate/deactivate integrity constraints?

Post

View All

Gaurav Malviya

How will you activate/deactivate integrity constraints?

By Gaurav Malviya in SQL Server on Jan 14 2014

0
1.7k
2

Post Your Answer

Apr, 2014 12
The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT.
- 0
Jan, 2014 14
The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT.
- 0

Where the integrity constraints are stored in data dictionary?

If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?