:::: MENU ::::

ANSI NULL Default (ANSI_NULL_DEFAULT) in SQL Server T-SQL

  • Nov 05 / 2008
  • 0
dbDigger, T-SQL Interview Questions

ANSI NULL Default (ANSI_NULL_DEFAULT) in SQL Server T-SQL

You can use ANSI NULL Default option to determine the default value of a column, alias data type, or CLR user-defined type for which the nullability is not explicitly defined. When set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, the default value is NULL, and when set to FALSE, the default value is NOT NULL. It is important to note that Connection-level settings override the default database-level setting. Similarly, columns that are defined with explicit constraints follow constraint rules regardless of this setting.

Consult us to explore the Databases. Contact us