Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to add include columns for indexes on ERwin Macro Expand / Collapse
Author
Message
Posted Tuesday, November 26, 2013 2:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 3:34 AM
Points: 2, Visits: 184
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.
Post #1517574
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse