IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_EmpleadosTipoId]') AND parent_object_id = OBJECT_ID(N'[dbo].[Empleados]'))
ALTER TABLE [dbo].[Empleados] DROP CONSTRAINT [CK_EmpleadosTipoId]
GO
IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_TercerosTipoId]') AND parent_object_id = OBJECT_ID(N'[dbo].[Terceros]'))
ALTER TABLE [dbo].[Terceros] DROP CONSTRAINT [CK_TercerosTipoId]
GO
ALTER TABLE [dbo].[Empleados]  WITH NOCHECK ADD  CONSTRAINT [CK_EmpleadosTipoId] CHECK  ((len([TipoId])>(0)))
GO
ALTER TABLE [dbo].[Empleados] CHECK CONSTRAINT [CK_EmpleadosTipoId]
GO
ALTER TABLE [dbo].[Terceros]  WITH NOCHECK ADD  CONSTRAINT [CK_TercerosTipoId] CHECK  (([TipoId]='D' OR [TipoId]='N' OR [TipoId]='X' OR [TipoId]='C' OR [TipoId]='E' OR [TipoId]='O' OR [TipoId]='U' OR [TipoId]='T' OR [TipoId]='R' OR [TipoId]='P' OR [TipoId]='Y'))
GO
ALTER TABLE [dbo].[Terceros] CHECK CONSTRAINT [CK_TercerosTipoId]
GO