SQL 创建学生信息表 student - 代码示例

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