摘要:
GOcreate table Department(Dep_Id CHAR(3) constraint PK_Dep_Id primary key not null,Depname VarChar(40) not null,Telephone char(16) null,Fax char(16) n 阅读全文
摘要:
GOcreate table Department(Dep_Id CHAR(3) constraint PK_Dep_Id primary key not null,Depname VarChar(40) not null,Telephone char(16) null,Fax char(16) n 阅读全文
摘要:
CREATE TABLE Student ( Sno CHAR(9) PRIMARY KEY, --列级完整性约束条件 Sname CHAR(20) UNIQUE, --Sname取唯一值 Ssex CHAR(2) , Sage SMALLINT, Sdept CHAR(20) )CREATE TA 阅读全文
摘要:
use shiyangocreate table Student(Sno char(9) not null,Sname char(20) not null,Sex char(2) null,Sage smallint null,Sdept char(20) null,primary key (Sno 阅读全文
|