USE SCommunity;
GO
DECLARE @chk sysname;
SELECT @chk = cc.name
FROM sys.check_constraints cc
JOIN sys.tables t ON t.object_id = cc.parent_object_id
JOIN sys.schemas s ON s.schema_id = t.schema_id
WHERE t.name='Entregas' AND s.name='dbo' AND cc.definition LIKE '%estado%';
IF @chk IS NOT NULL
  EXEC('ALTER TABLE dbo.Entregas DROP CONSTRAINT ' + QUOTENAME(@chk));
ALTER TABLE dbo.Entregas
  ADD CONSTRAINT CK_Entregas_Estado CHECK (estado IN ('Enviada','Aprobada','Rechazada','Corregido'));
GO
