--use test1;
--create table S
--( sNo varchar(10) primary key,
-- sN varchar(6) unique,
-- sex nchar(1),
-- age int,
-- dept nvarchar(5) )
--create table C
-- ( cNo varchar(6) primary key,
-- cN nvarchar(6),
-- cT int )
--create table SC
--( sNo varchar(6) not null,
-- cNo varchar(6) not null,
-- score numeric(4,1)
-- constraint SC_prim primary key(sNo, cNo) )
--create table SC
--( sNo varchar(10) not null foreign key references S(sNo),
-- cNo varchar(6) not null foreign key references C(cNo),
-- score numeric(4,1) check(score >=0 and score <= 100),
-- constraint S_C_prim primary key (sNo, cNo) )
-- complete student table
create table S
( sNo varchar(15) not null primary key ,
sN varchar(15) not null,
sex nvarchar(1) not null default '男' check(sex = '男' or sex = '女'),
age int not null check(age >= 15 and age <= 70),
dept nvarchar(10) not null )
约束条件创建表--SQLSever
最新推荐文章于 2022-10-16 20:40:46 发布