How to add include columns for indexes on ERwin Macro

• baskaran.rakkapan

  SSC Enthusiast

  Points: 136

  More actions

  November 26, 2013 at 2:49 am

  #285533

  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.