Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
How to show Indexes which are present in a Tables?
on 11/5/2014 | Category:
Sql Server Interview questions
| Views: 1291 |
Select from following answers:
Both a and b
None of these.
sp_helpindex is a System Stored Procedure which is used to display Indexes on Tables.
execute sp_helpindex table_name;
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
Many Interviews |
< Previous :
How to display primary and foreign keys informatio ...
Next > :
Which keyword is used to call Stored Procedure fro ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
Which keyword is used to call Stored Procedure from Query Window?
In Sql Server,which command is used to get Stored procedures definitio ...
In Oracle,which command is used to get Table Structure?
Give an example of Sp_Help system stored procedure?
What is an alternating way of showing Table Structures in Sql Server?
What is the significance of DESCRIBE command in SQL Server?
What is the use of INTO keyword in LINQ?
How to get Age from any Date?
Latest Interview Questions
How do we retrive position of html in jquery ?
__________ and __________ introduced with C#4.0 as a new features?
What is the calling order of components when angular js application st ...
In C#, the keyword used to pass the arguments by reference is?
In C#, the keyword used to access the base class members from the deri ...
In C#, the following keyword used to allocate the for a class's in ...
In C#, the keyword used to create an object to a class or struct is?
In C#, the process of grouping the related methods and variables (memb ...