INTERVIEW QUESTIONS DATABASE MS SQL SERVER DETAILS

Question: How To View Existing Indexes on an Given Table using sys.indexes?

Answer: Another way to view existing indexes defined for a given table is to use the system view called "sys.indexes". The tutorial exercise shows you how many indexes were defined from the previous tutorial on table "ggl_links":

USE GlobalGuideLineDatabase;
GO

SELECT * FROM sys.indexes WHERE object_id = (
SELECT object_id FROM sys.tables WHERE name = 'ggl_links'
);
GO

object_id name index_id type_desc is_unique

--------- ------------- -------- ---------- ---------

421576540 NULL 0 HEAP 0

421576540 ggl_links_id 2 NONCLUSTERED 0

421576540 ggl_links_url 3 NONCLUSTERED 0

Another way to view existing indexes defined for a given table is to use the system view called "sys.indexes". The tutorial exercise shows you how many indexes were defined from the previous tutorial on table "ggl_links":

USE GlobalGuideLineDatabase;
GO

SELECT * FROM sys.indexes WHERE object_id = (
SELECT object_id FROM sys.tables WHERE name = 'ggl_links'
);
GO

object_id name index_id type_desc is_unique

--------- ------------- -------- ---------- ---------

421576540 NULL 0 HEAP 0

421576540 ggl_links_id 2 NONCLUSTERED 0

421576540 ggl_links_url 3 NONCLUSTERED 0 Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question