Looking for script to list all indexes in database, write to table
-
I was looking for a script that would enumerate a database for all indexes and associated information and write all that information to a permenant table.
Appreciate replies
-
I haven't got one to hand but it's all in the sysindexes table. Probably wouldn't take long to write one.
-
There is one in the script section here -> just lOOk
_/_/_/ paramind _/_/_/ -
Here is the select statement, i don't know whether it is useful for you or not.
use
select a.name table_name,xtype,b.name Index_name from sysobjects a,sysindexes b
where a.xtype='U' and a.id=b.id order by a.name
Ramaa
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply