I need to extract the DDL for the indexes on a database via sql query. Can
this be done?
Re: Extracting DDL
I don't believe that you can get to the script generation via TSQL but you
can using SQL-DMO.
What about sp_helpindex. It return everything about the index. You'd just
have to parse the result set and create the CREATE INDEX command.
Michael Levy MCSD, MCDBA, MCT
"Charles Nelson" <Charles.Nelson@dresdnerRCM.com> wrote in message
> I need to extract the DDL for the indexes on a database via sql query.
> this be done?
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center