IF NOT EXISTS (SELECT 1 FROM SYSCOLUMNS WHERE ID=OBJECT_ID('BC_LANC_CNAB_LOTE_BC_LANC') AND NAME = 'CD_CTR_DP')
BEGIN
	ALTER TABLE dbo.BC_LANC_CNAB_LOTE_BC_LANC ADD CD_CTR_DP int NULL

	ALTER TABLE dbo.BC_LANC_CNAB_LOTE_BC_LANC ADD CONSTRAINT
		DF_BC_LANC_CNAB_LOTE_BC_LANC_CD_CTR_DP DEFAULT ((0))FOR CD_CTR_DP
END
	
