文章目录
1.创建表
use teaching
go
create table course
(cno char(4) primary key,
cname nvarchar(20) not null,
classhour tinyint ,
credit tinyint
)
2.修改表
修改字段属性:
use teaching
go
alter table student
alter column sname nvarchar(20) null
添加字段:
use teaching
go
alter table student
add teacher nvarchar(10)
删除字段:
use teaching
go
alter table student
drop column sage
3.primary key 约束
定义表时设置主键约束:
use teaching
go
create table sc
(sno char(7),
cno char(4),
score int,
constrauint ok_js primary key(sno,cno)–pk_js是约束名
)