How to view existing indexes on an given table using sys.indexes?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How many index keys possible for a table

6 Answers  


employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  


Can you explain the role of each service?

1 Answers  


What is sqlcmd?

0 Answers  


How to rebuild the master database?

0 Answers  






How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,


How can change procedure in sql server?

0 Answers  


What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  


What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  


How to how to convert numeric expression data types using the convert() function??

0 Answers  


What is resource db in sql server?

0 Answers  


Advantages and disadvantages of stored procedures.

2 Answers   HCL,


Categories