Extracting DDL


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Extracting DDL

  1. #1
    Charles Nelson Guest

    Extracting DDL


    I need to extract the DDL for the indexes on a database via sql query. Can
    this be done?

  2. #2
    Michael Levy Guest

    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.

    -Mike
    --
    Michael Levy MCSD, MCDBA, MCT
    Consultant
    GA Sullivan
    michaell@gasullivan.com

    "Charles Nelson" <Charles.Nelson@dresdnerRCM.com> wrote in message
    news:39047c88$1@news.devx.com...
    >
    > I need to extract the DDL for the indexes on a database via sql query.

    Can
    > this be done?




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center