IF EXISTS(SELECT * FROM sys.indexes WHERE name = 'IX_ConnectionLog_CustomerID' AND object_id = OBJECT_ID(N'dbo.ConnectionLog'))
BEGIN
    drop index IX_ConnectionLog_CustomerID on dbo.ConnectionLog;
END