IF  EXISTS (SELECT * FROM sys.check_constraints WHERE object_id = OBJECT_ID(N'[dbo].[CK_NomConceptosBaseTrfa]') AND parent_object_id = OBJECT_ID(N'[dbo].[NomConceptos]'))
ALTER TABLE [dbo].[NomConceptos] DROP CONSTRAINT [CK_NomConceptosBaseTrfa]
GO
ALTER TABLE [dbo].[NomConceptos]  WITH NOCHECK ADD  CONSTRAINT [CK_NomConceptosBaseTrfa] CHECK  (([BaseTrfa]='BD' OR [BaseTrfa]='SM' OR [BaseTrfa]='SB' OR [BaseTrfa]='TD' OR [BaseTrfa]='SD' OR [BaseTrfa]='0'))
GO
ALTER TABLE [dbo].[NomConceptos] CHECK CONSTRAINT [CK_NomConceptosBaseTrfa]