﻿IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS  WHERE TABLE_NAME = 'parceiro' 
           AND COLUMN_NAME = 'complemento'           
           AND CHARACTER_MAXIMUM_LENGTH < 255)
BEGIN
    ALTER TABLE parceiro ALTER COLUMN complemento VARCHAR(255);
END