利用SQL命令创建部门表dept. 能告诉我代码吗?

2025-03-23 14:03:05
推荐回答(2个)
回答1:

create table dept (
dept_id char(4) not null primary key,
dept_name varcha(10) not null);
comment on column dept .dept_id is 部门代码;
comment on column dept .dept_name is 部门名称;

回答2:

create table dept (
deptno char(4) not null primary key,
deptname varcha(10) not null);