创建表的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='女')