创建表的SQL语句

CREATE TABLE Grade(GradeId [int]IDENTITY(1,1) NOT NULL,GradeName nvarchar(20) not null)--添加主键ALTER TABLE Grade ADD  CONSTRAINT pK_GradeId primary key (GradeId)CREATE TABLE Stu(StuNo [int]IDENTITY(1,1) NOT NULL,StuName nvarchar(10) NOT NULL,StuSex char(2) not null default('男'),StuAddress nvarchar(50) not null default('地址不详'),stuEmail nvarchar(50) ,GradeId int not null)--添加主键ALTER TABLE Stu ADD  CONSTRAINT pK_StuNo primary key (StuNo)--建立外键ALTER TABLE Stu  ADD  CONSTRAINT FK_GradeId FOREIGN KEY (GradeId) REFERENCES Grade(GradeId)--建立检查约束ALTER TABLE Stu  ADD  CONSTRAINT CK_stuEmail CHECK (stuEmail LIKE '%@%')ALTER TABLE Stu  ADD  CONSTRAINT CK_StuSex CHECK (StuSex ='男' or StuSex='女')