Select from following answers:- sp_helpindex
- sp_showindex
- Both a and b
- None of these.
- All Above
sp_helpindex is a System Stored Procedure which is used to display Indexes on Tables.
Syntax:-
execute sp_helpindex table_name;
For Example:-
execute sp_helpindex employee_master;
It will show Clustered,Non-Clustered Indexes which includes index name,index description and index keys(on which columns).
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator