Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nishu81
Starting Member
11 Posts |
 Posted - 2009-11-26 : 09:00:56
|
| when i use SP_helpconstraint <table name> it gives info whether constraint is enabled or not however when I used it is was giving info only about check constraint (i.e it is enabled or disable) for other constraint like default constraint or primary key constraint or foreign key constraints the status _enabled column was n/a Can some please explain how we can find if other constraints are active or not .Also if we can temporarily disable other constraints just like check constraints or not . |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-11-26 : 09:06:15
|
| EXEC SP_help <table name>MadhivananFailing to plan is Planning to fail |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-27 : 01:51:48
|
quote:
Originally posted by nishu81
when i use SP_helpconstraint <table name> it gives info whether constraint is enabled or not however when I used it is was giving info only about check constraint (i.e it is enabled or disable) for other constraint like default constraint or primary key constraint or foreign key constraints the status _enabled column was n/a Can some please explain how we can find if other constraints are active or not .Also if we can temporarily disable other constraints just like check constraints or not .
see belowhttp://msdn.microsoft.com/en-us/magazine/cc163442.aspx |
|
|
|
|
|
|
Doubt in SP_helpconstraint