GETANSINULL (Transact-SQL)

'database'

Is the name of the database for which to return nullability information. databaseis either char or nchar. If char, database is implicitly converted to nchar.

int

When the nullability of the specified database allows for null values and the column or data type nullability is not explicitly defined, GETANSINULL returns 1. This is the ANSI NULL default.

To enable the ANSI NULL default behavior, one of these conditions must be set:

• ALTER DATABASE database_name SET ANSI_NULL_DEFAULT ON

• SET ANSI_NULL_DFLT_ON ON

• SET ANSI_NULL_DFLT_OFF OFF

The following example returns the default nullability for the AdventureWorks2008R2 database.

USE AdventureWorks2008R2;
GO
SELECT GETANSINULL('AdventureWorks2008R2')
GO

Here is the result set.

------

1

(1 row(s) affected)

Reference