How to add include columns for indexes on ERwin Macro

  • I'm using ERwin Data modeler 7.3.4.1822, here I'm facing some issue that I'm exporting schema generation through ERwin Macro that mentioned as below,

    -- creating indexes nonclustered

    %foreachindex()

    { %if (%== (%substr(%indextype,1,2),"IE"))

    {if not exists (select 1 from sys.indexes where object_name(object_id) = '%tablename' and name = '%indexname')

    begin

    create nonclustered index %indexname on %tablename (%ForEachIndexMem(,","){%AttName} )

    end

    }}

    In above macro code exporting all indexes properly. But this is not generating the includes columns if it is exist on the table. I want to generate the indexes include columns.

    Kindly give the solution for this issue.

    Thanks,

    Baskaran.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply