IF ((SELECT character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'parceiro' AND COLUMN_NAME = 'EMAIL') < 100) BEGIN ALTER TABLE parceiro ALTER COLUMN EMAIL VARCHAR(100) NULL; END