﻿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