11111

Create table student

Sno CHAR(7) NOT NULL,

Sname VARCHAR(16),

Ssex CHAR(2) DEFAULT、男·CHECK(3sex=男·OR 3sex=女

Sage SMALLINT CHECK(Sage>=1s AND Sage<=45)

Sdept CHAR(2),

PRIMARY KEY(Sno)

ENGINE=InnoDB;

Create table course

Cno CHAR(2)NOT NULL,

Cname VARCHAR(20）,

Cpno CHAR(2),

Credit SMALLINT

PRIMARY KEY(Cno)

foreign key(cpno)

ENGINE=InnoDB;

references course(cno)

Create table sc

sno char(7) not null,

cno char(2)

not null

grade smallint null check(grade is null or (grade between 0 and100))

Primary key(sno,cno)

Foreign key(sno) references student(sno),

Foreign key(cno) references course(cno)

ENGINE=InnoDB;

（2）列出jxgl数据库中的所有表。