smalldatetime column with default value : smalldatetime « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. smalldatetime

3> CREATE TABLE StudentsArchive (
4> AID int IDENTITY(1,1) PRIMARY KEY CLUSTERED,
5> type nvarchar(6) NOT NULL,
6> whenchanged smalldatetime NOT NULL DEFAULT Getdate(),
7>
8> StudentID int,
9> nFirstName nvarchar(30),
10> nLastName nvarchar(50),
11> oFirstName nvarchar(30),
12> oLastName nvarchar(50)
13> )
14> GO
1>
2> drop table StudentsArchive;
3> GO
1>