IF ((SELECT character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'perfil' AND COLUMN_NAME = 'ceppernoite') <= 9 ) BEGIN ALTER TABLE perfil ALTER COLUMN ceppernoite VARCHAR(10) NULL; END IF ((SELECT character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'perfil' AND COLUMN_NAME = 'cepcirculacao') <= 9 ) BEGIN ALTER TABLE perfil ALTER COLUMN cepcirculacao VARCHAR(10) NULL; END