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>