---创建表
create table student
(
id int identity(1,1) primary key,
stuName nvarchar(10),
stuSex bit,
stuAge int
)
---- 插入
insert into student(stuName,stuSex,stuAge) values('张一',0,12);
insert into student(stuName,stuSex,stuAge) values('张二',1,13);
insert into student(stuName,stuSex,stuAge) values('张三',0,14);
insert into student(stuName,stuSex,stuAge) values('张四',1,15);
insert into student(stuName,stuSex,stuAge) values('张五',0,16);
insert into student(stuName,stuSex,stuAge) values('张六',1,17);
select * from student
----修该
update student set stuName='修改' where stuAge=15
----删除
delete from student where stuAge=16
----添加约束
--alter table 表名 add constraint 约束名 约束表达式
--主键约束
--- alter table 表名 add constraint
---PK_表名_字段名 primary key(字段名)
create table PersonCon1
(
id int not null,
stuName nvarchar(10),
stuSex nchar(1),
inputtime datetime,
)
---添加主键
alter table PersonCon1
add constraint PK_PersonCon1_id primary key(id);
--添加唯一键
alter table PErsonCon1
add constraint UQ_PersonCon1_stuName unique(stuName);
--检查约束
alter table PersonCon1
add constraint CK_PersonCon1_stuSex
check(stuSex='男' or stuSex='女');
--默认约束
alter table PersonCon1
add constraint DF_PersonCon1_inputtime
default (getdate()) for inputtime;
--快捷方式
/*
alter table 表名
add
constraint 约束名1 约束表达式1
constraint 约束名1 约束表达式1
constraint 约束名1 约束表达式1
constraint 约束名1 约束表达式1
constraint 约束名1 约束表达式1
*/