Enable a column to optionally not require a value by designating it as a nullable column : Constraints Basics « Constraints « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Constraints
3. Constraints Basics

Enable a column to optionally not require a value by designating it as a nullable column

1> -- Nullability
2>
3> -- Enable a column to optionally not require a value by designating it as a
4> -- nullable column.
5>
6> CREATE TABLE MyTable
7>      ( Category nVarChar(50) NOT NULL
8>      , MyDescription nVarChar(50)
9> )
10> INSERT MyTable (Category) VALUES ('Category1')
11>
12> SELECT * FROM MyTable
13> GO

(1 rows affected)
Category                                           MyDescription
-------------------------------------------------- -------------------------------
Category1                                          NULL

(1 rows affected)
1>
2> drop table MyTable
3> GO
1>
           
       

Related examples in the same category