what is the code to see the all the indexes

microsoft.public.sqlserver.programming

13 Sep 2006 10:47 PM

SQL Ken

Hi, what is the sql code to to display all the index and property of a
table?
Thanks

Ken

13 Sep 2006 11:13 PM

Greg Linwood

sp_help [tablename] shows indexes, columns, constraints etc.

Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood

Show quote

"SQL Ken" <SQL***@gmail.com> wrote in message
news:1158187627.683052.71990@m73g2000cwd.googlegroups.com...
> Hi, what is the sql code to to display all the index and property of a
> table?
> Thanks
>
> Ken
>

13 Sep 2006 11:16 PM

Hari Prasad

Hi,

1. To get the extended property of table , take a look into function

::FN_LISTEXTENDEDPROPERTY

2. To get the index information. Either use one:-

   1. sp_help <table_name>
   2. sp_helpindex <Table_name>
   3. Query the sysindexes

Tahnks
Hari
SQL Server MVP

Show quote

"SQL Ken" wrote:

> Hi, what is the sql code to to display all the index and property of a
> table?
> Thanks
>
> Ken
>
>

14 Sep 2006 6:32 AM

Have a look at this example:
http://milambda.blogspot.com/2005/09/index-properties-with-kick.html

ML

---
http://milambda.blogspot.com/