DECLARE @schema_name VARCHAR(50)
DECLARE @table_name VARCHAR(100)
DECLARE @sql VARCHAR(500)
DECLARE @new_filegroup VARCHAR(100)

SET @schema_name = 'Person'
SET @table_name = 'Contact'
SET @new_filegroup = 'AW_CDC'


IF NOT EXISTS (SELECT * FROM sys.filegroups F WHERE name = @new_filegroup)
BEGIN
	PRINT 'Invalid Filegroup'
	RETURN
end



IF  NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[cdc].['+@schema_name+'_'+@table_name+'_CT]') AND name = @schema_name+'_'+@table_name+'_CT_clustered_idx')
BEGIN 
	PRINT 'No CDC table for specified schema and table name'
	RETURN
END
ELSE
begin
SET @sql = 'DROP INDEX ['+@schema_name+'_'+@table_name+'_CT_clustered_idx] ON [cdc].['+@schema_name+'_'+@table_name+'_CT] WITH ( ONLINE = OFF )'
EXEC (@sql)

SET @sql = '
CREATE UNIQUE CLUSTERED INDEX ['+@schema_name+'_'+@table_name+'_CT_clustered_idx] ON [cdc].['+@schema_name+'_'+@table_name+'_CT] 
(
	[__$start_lsn] ASC,
	[__$seqval] ASC,
	[__$operation] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) 
ON '+@new_filegroup

EXEC (@sql)
end