Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 index

Author  Topic 

toftof
Starting Member

2 Posts

Posted - 2004-09-15 : 11:35:03
hi,

how can I retrieve all the indexes of a table created by a User with sql or anything else ?
thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-09-15 : 11:42:39
try:

select * from sysindexes

also look at the INFORMATION_SCHEMA views



Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -