把这个表用SQL语句建立

字段名类型长度特殊性质主键 SNO char 4 not null primary key AREA int 0~500

2025-12-14 17:41:18

推荐回答（3个）

回答1：

create table mybase
(
SNO char(4) not null,
AREA int,
PRIMARY KEY (SNO),
check (AREA between 0 and 500)
)

回答2：

create table mybase
(
SNO char(4) not null,
AREA int,
PRIMARY KEY (SNO)
)

回答3：

create table XXX
(SNO char(4) constraint PK_SNO primary key,
AREA int check (AREA between 0 and 500))