﻿IF COL_LENGTH('dbo.remConceptos', 'pagoElectronico') IS NULL
BEGIN
    ALTER TABLE dbo.remConceptos
        ADD pagoElectronico INT NOT NULL
            CONSTRAINT DF_remConceptos_pagoElectronico DEFAULT (0);
END
GO

-- Verificación
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'remConceptos' AND COLUMN_NAME = 'pagoElectronico';
GO
