Re: List of All Indexes

Rajendra Singh (rajsingh@hotmail.com) wrote: : I am trying to compose a single SQL query which will list all table names, index : names, and the columns on which those indexes were created. For example, say I : had created the index "customer" using the following query: : "What is understood need not be discussed." - Loren Adams i have a script that will create a geenric update satistics script for all the tables in a database. the sql i use sounds like what you are looking for , but i don't have access to it right now. e-mail me at mickm@ix.netcom.com, and i will send you the script and you can look at the output and the sql statments. mickm -- _____________________________________________________________________________ Mickey Mestel mickm@netcom.com -on a beach in thailand to a beautiful, stoned, norwegian woman: "..yeah, it's just another foreign country without ice." -----------------------------------------------------------------------------