Home Forums Article Discussions Article Discussions by Author Discuss content posted by Oxygen SQL Server 2005: Script all Indexes RE: SQL Server 2005: Script all Indexes
Jonathan AC Roberts
SSCoach
Points: 18263
More actions
January 22, 2013 at 9:36 am
#1579708
Jeff,
The following lines in the SP exclude the primary key and any indexes that are created via adding a unique constraint rather than adding a unique index.
AND SI.is_primary_key = 0
AND SI.is_unique_constraint = 0