数据库如何添加约束

--主键约束  外键约束  unique约束(唯一约束)  check约束  default约束

create table DemoTable--创建表

(

Id int identity(1,1) primary key not null,--设置主键约束

DemoNo varchar(50) unique not null,--设置unique约束(唯一约束)

DemoName nvarchar(50) not null,

TypeId int not null foreign key references DemoType(TypeId),--设置外键

Price decimal(18,2) check(Price<10000) default (0.00) not null,--check约束

DemoCount int default (0) null--default约束 缺省值 

)

go

--创建表后再添加约束

create table DemoTable--创建表

(

Id int identity(1,1) not null,

DemoNo varchar(50) not null,

DemoName nvarchar(50) not null,

TypeId int not null,

Price decimal(18,2) not null,

DemoCount null

)

go

--主键

alter table DemoTable add constraint PK_DemoTable primary key(Id)

--外键

alter table DemoTable add constraint FK_DemoTable foreign key(TypeId) references DemoType(TypeId)

--unique约束(唯一约束)

alter table DemoTable add constraint IX_DemoTable_DemoNo unique(DemoNo)--unique(列名)

--多个列唯一性约束

alter table DemoTable add constraint IX_DemoTable_DemoNo unique(DemoNo,DemoName)

--check约束

alter table DemoTable add constraint CK_DemoTable_Price check(Price<10000)--check(逻辑表达式)

--default约束

alter table DemoTable add constraint DF_DemoTable default (0) for DemoCount--default(缺省值) for 列名