--主键约束 外键约束 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 列名