Create Table创建ACCESS、MSSQL和SQLite数据库表

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;