Select from following answers:- sp_helpconstraint
- sp_showconstraint
- Both a and b
- None of these.
- All Above
sp_helpconstraint is used to show primary and foreign keys information on Tables.It is also a System Stored Procedure.
Syntax:-
exec sp_helpconstraint table_name;
For Example:-
exec sp_helpconstraint employee_master;
It shows the constraint type,constraint name,update action,delete action,constraint keys like columns in which they are created.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator