约束 | 描述 |
PRIMARY KEY | 主键约束(隐式的UNIQUE,隐式的NOT NULL,非隐式的GENERATED ALWAYS AS IDENTITY) |
REFERENCES 或 FOREIGN KEY … REFERENCES | 外键约束 |
UNIQUE | 唯一约束 |
NOT NULL | 非空约束 |
GENERATED ALWAYS AS IDENTITY | 自递增约束(非隐式的UNIQUE,隐式的NOT NULL) |
DEFAULT | 默认值约束 |
CHECK | CHECK 约束 |
原创文章,作者:huoxiaoqiang,如若转载,请注明出处:https://www.huoxiaoqiang.com/experience/mysql/38292.html