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.