>ALTER TABLE [dbo].[MyTable] ADD CONSTRAINT [IX_CATEGORY_UNIQUE] UNIQUE NONCLUSTERED >( > [CATEGORY] ASC >)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = >OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] >GO >>
TEXT TO lcSQL NOSHOW ALTER TABLE [dbo].[MyTable] DROP CONSTRAINT [IX_CATEGORY_UNIQUE] ENTEXT IF SQLEXECT(sqlHandler, lcSQL) < 0 AERROR(laError) MessageBox(laError[1,2]) RETURN ENDIF TEXT TO lcSQL NOSHOW ALTER TABLE [dbo].[MyTable] ADD CONSTRAINT [IX_CATEGORY_UNIQUE] UNIQUE NONCLUSTERED ( [SITE_NO],[CATEGORY] )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ENDTEXT IF SQLEXECT(sqlHandler, lcSQL) < 0 AERROR(laError) MessageBox(laError[1,2]) ENDIF