ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 完整性约束

完整性约束

原创 Linux操作系统 作者:linden1019 时间:2010-04-25 10:52:22 0 删除 编辑

NOT NULL: Disallows nulls (empty entries) in a table’s column.

UNIQUE KEY: Disallows duplicate values in a column or set of columns.

PRIMARY KEY: Disallows duplicate values and nulls in a column or set of
columns.

FOREIGN KEY: Requires each value in a column or set of columns to match a
value in a related table’s UNIQUE or PRIMARY KEY. FOREIGN KEY integrity
constraints also define referential integrity actions that dictate what Oracle
should do with dependent data if the data it references is altered.

CHECK: Disallows values that do not satisfy the logical expression of the
constraint.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/58174/viewspace-660675/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: SQL语句分类
请登录后发表评论 登录
全部评论

注册时间:2010-04-24

  • 博文量
    9
  • 访问量
    4022