主键(标识列):
ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY
唯一约束:
UserName VARCHAR(50) NOT NULL UNIQUE
默认约束:
UserPass VARCHAR(20) NOT NULL DEFAULT('123456')
检查约束:
Age INT NOT NULL CHECK(Age>18)
主外键约束:(外键表中建立约束)
UserID INT NOT NULL REFERENCES UserInfo(ID)
级联删除:
UserID INT NOT NULL REFERENCES UserInfo(ID) ON DELETE CASCADE
级联更新:
UserID INT NOT NULL REFERENCES UserInfo(ID) ON UPDATE CASCADE
级联更新、删除
UserID INT NOT NULL REFERENCES UserInfo(ID) ON DELETE CASCADE ON UPDATE CASCADE
其中,UserInfo为主键表表名