script index

i have four indexes on a table.

i was wondering if anybody can tell me how to script an existing index?

i know how to do this in 2000...wondering how to do in 2005

thanks

? Hi RookieDBA, In Query Analyzer: 1. Hit F8 to open the object explorer; 2. Locate correct database; go to User Tables, find right table and drill down to "Indexes" 3. Right-click Index; choose Script Object to New Window As / Create -- Hugo Kornelis, SQL Server MVP <RookieDBA@.discussions..microsoft.com> schreef in bericht news:ec51452a-622b-48dc-aa2b-dc2ebb7db970@.discussions.microsoft.com... i have four indexes on a table. i was wondering if anybody can tell me how to script an existing index? i.e the sql used to create the index thanks