WHY CHECK CONSTRAINT IS NOT WORKING

  • HI ALL,

    I CREATED A TABLE AND APPLIED CHECK CONSTRAINT USING IN AND LATER I AM ENTERING DATA WHY CHECK CONSTRAINT IS ACCEPTING ALL THE INSERT STATEMENTS.

    CREATE TABLE TEST1(SNO INT,

    NAME VARCHAR(20),

    STATUS CHAR(1) CONSTRAINT CHK_1 CHECK (STATUS IN (NULL,'N','Y')) DEFAULT NULL)

    INSERT INTO TEST1 VALUES(1,'ABC','')

    INSERT INTO TEST1(SNO,NAME) VALUES(1,'ABC')

    INSERT INTO TEST1(SNO,NAME,STATUS) VALUES (1,'ABC','T')

    THANKS,

    SAI

  • Cross post...

    Answers here please

    http://www.sqlservercentral.com/Forums/Topic741440-149-1.aspx

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply