SQL 创建 student 表格教程 - 结构设计与完整性约束

CREATE TABLE student ( sno CHAR(4) PRIMARY KEY, sname NVARCHAR(20) NOT NULL, ssex NCHAR(1) DEFAULT '男' CHECK(ssex='男' OR ssex='女'), classname NVARCHAR(20) NOT NULL, birthday SMALLDATETIME, tell_phone NVARCHAR(20) );