TABLE 1: ANSI_NULL_DEFAULT Decision Table
SET ANSI_NULL_DEFAULT_ON ON OFF ON OFF
SET ANSI_NULL_DEFAULT_OFF OFF ON ON OFF
CREATE TABLE columns NULL by default? Yes No Impossible condition Behavior determined by the value of sp_dboption ANSI null default