SQL Server Performance Forum – Threads Archive

How can I generate Index script from a database

I want to generate Index script from one database, This database having around 100 tables. So I want to retrieve the only Index from this 100 tables. Could you please help me out here.

Try this select ind.name, obj.name from sysindexes ind,sysobjects obj
where ind.id = obj.id Cheers
Sat

The above will give all the indexes with respective table names for databases, probably you can refine it more to add syscolumns to get columns they apply to as well. Cheers
Sat

If you want to generate scripts of all indexes created or any object you need
to open Microsoft SQL server management Studio —> Right click on Database —> Tasks –>Generate Scripts This will open script wizard , which is freindly GUI where you select and deselect the objects of your choice. Cheers
Sat

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Nice solution to make use of generate script wizard in SQL 2005, as it is ignored by users many times. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com</a> @<a target="_blank" href=http://www.askasqlguru.com/>http://www.askasqlguru.com/</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</center>

or you can use this free console app I wrote – it’s useful for automating script generation since you can launch it from a bat file, etc. http://www.codeplex.com/scriptdb www.elsasoft.org

]]>