GETANSINULL (Transact-SQL)
Returns the default nullability for the database for this session.
.gif "Topic link icon")
Syntax
GETANSINULL ( [ 'database' ] )
Arguments
- '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.
Return Types
int
Remarks
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
Examples
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)