Create TABLE [UserTB](
    [Id] counter(1,1) PRIMARY KEY NOT NULL,
    [Name] text(50) NOT NULL,
    [Age] short NOT NULL,
    [Sex] yesno NOT NULL,
    [Remarks] memo,
    [CreateTime] datetime NOT NULL
)

Create TABLE [dbo].[UserTB](
    [Id] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [Name] [nvarchar](50) NOT NULL,
    [Age] [int] NOT NULL DEFAULT 0,
    [Sex] [bit] NOT NULL,
    [Remarks] [nvarchar](300) NULL,
    [CreateTime] [smalldatetime] NOT NULL
)

Create TABLE [UserTB](
    [Id] INTEGER PRIMARY KEY ASC AUTOINCREMENT NOT NULL,
    [Name] NVARCHAR(50) NOT NULL,
    [Age] INTEGER NOT NULL DEFAULT 0,
    [Sex] BOOLEAN NOT NULL,
    [Remarks] NVARCHAR(300),
    [CreateTime] DATETIME NOT NULL
);

insert into UserTB(id,name,age,sex,remarks,createtime) select 初始值-1,'',0,0,'',datetime('now');
delete from usertb;