|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
what is the code to see the all the indexesHi, what is the sql code to to display all the index and property of a
table? Thanks Ken sp_help [tablename] shows indexes, columns, constraints etc.
Regards, Greg Linwood SQL Server MVP http://blogs.sqlserver.org.au/blogs/greg_linwood Show quoteHide 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 > 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 quoteHide quote "SQL Ken" wrote: > Hi, what is the sql code to to display all the index and property of a > table? > Thanks > > Ken > > Have a look at this example:
http://milambda.blogspot.com/2005/09/index-properties-with-kick.html ML --- http://milambda.blogspot.com/ 
Other interesting topics
Bulk Insert To Temp Table - Security Issue
Deleting a record dynamically What am I missing with this simple query? Passing username to sql server from an app SQL search for similar records with different dates UPDATE TOP 1 For insert trigger problem Is it possible to trace all statements to a specific table?... Any need for TEXT/NTEXT column types in SQL2005 Joined Query With Optional Data |
|||||||||||||||||||||||
