USE TM_RODELER
GO

SELECT *
FROM amlTransaction

IF EXISTS (
		SELECT *
		FROM sys.tables AS t
		INNER JOIN sys.columns AS c ON t.object_id = c.object_id
		WHERE t.NAME = 'amlTransaction'
			AND c.NAME = 'CreditCardLastFourDigits'
		)
BEGIN
	ALTER TABLE amlTransaction

	DROP COLUMN CreditCardLastFourDigits
END
GO

ALTER TABLE amlTransaction ADD CreditCardLastFourDigits VARCHAR(10)
GO