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>