«
»

How to find the Index fields of table in SQL Server

Below is the query on finding the Index fields of the table

Returns Primary key

  1. select * from sys.objects where parent_object_id = object_id(N'TABLE_1')

Returns All

  1. SELECT * FROM SYS.index_columns   where object_id= object_id(N'TABLE_1')

, ,

This entry was posted on Thursday, August 26th, 2010 at 2:58 pm and is filed under Constraint, Database. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

  1. No comments yet.
(will not be published)
Submit Comment

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Subscribe to comments feed
  1. No trackbacks yet.

SetPageWidth