﻿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