关于在IBConsole里创建数据库表格的问题。急!
急!急!急!
I在IBConsole里用Interactive SQL工具创建员工个人信息表,但怎样都不能通过编释,提示错误:
Dynamic SQL Error
SQL error code = -842
Short integer expected ...
请各位Proficient看一下下面代码哪儿出错了?谢了!
/* Table:Person,Owner:MyMISDBA */
create table Person (
ID char(6) not null,
PassWD char(20) not null,
Authority char(1) default'0',
Name varchar(10),
Sex char(1) defualt 'M' not null,
Birthday timestamp,
Department char(3),
Job char(3),
Edu_Level char(1),
Specialty varchar(20),
Address varchar(50),
Tel varchar(20),
Email varchar(50),
State char(1) default 'T',
Remark varchar(40000),
constraint Person_ID primary key(ID));