test.sql

在VC下访问和创建Access数据库的例子

create table test
(
	name text(20) WITH COMPRESSION not null,
	score decimal(12,4) not null default 0,
	ID smallint not null default 0,
	birthday date,
	sex char(1),
	CONSTRAINT CK_CH_SEX Check(SEX in ('N','V')),
	CONSTRAINT PK_ID Primary Key (ID)
);