SQL -SERVER示例学校学生课程数据库
CREATE DATABASE STUDENTDB
GO
USE STUDENTDB
GO
CREATE TABLE STUDENT
(
SNO CHAR(10) PRIMARY KEY,
SNAME CHAR(20) NOT NULL,
SSEX CHAR(2) NOT NULL DEFAULT '男',
SMAJOR CHAR(20) NOT NULL,
SDEPT CHAR(20) NOT NULL,
SAGE TINYINT,
TEL CHAR(15),
EMAIL VARCHAR(30),
C.
原创
2020-05-20 23:27:52 ·
1744 阅读 ·
1 评论