Search code examples
sqlt-sqlnullablecreate-table

NULL sets default value or nullability?

In a CREATE TABLE I see the following for an existing table:

[FooColumn] NUMERIC (19, 3) NULL,

I am a total n00b to T-SQL and only a very infrequent user of normal SQL. Does the NULL mean that the field defaults to null, or that the field is nullable?

For e.g. does the following make sense, meaning the latter case is true, [FooColumn] NUMERIC (19, 3) NULL DEFAULT 1.5,?

Solution

  • It means the field is nullable. It will default to NULL. Per your update, to create a decimal field that defaults to 1.5 and is also nullable:

    [FooColumn] NUMERIC (19, 3) DEFAULT 1.5 NULL,