search

Home >Database >Mysql Tutorial >Oracle 约束enable/disable novalidate

Oracle 约束enable/disable novalidate

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 16:57:381301browse

oracle 对constraint的开启和关闭共有四种:enable validate;enable novalidate;disable validate;disable novalidate。启用约束:

Oracle 对constraint的开启和关闭共有四种:enable validate;enable novalidate;disable validate;disable novalidate。

启用约束:

enable( validate) : 启用约束,创建索引,对已有及新加入的数据执行约束.          ===> 默认等价于enable

enable novalidate : 启用约束,创建索引,仅对新加入的数据强制执行约束,而不管表中的现有数据.

禁用约束:

disable( novalidate): 关闭约束,删除索引,可以对约束列的数据进行修改等操作.    ===> 默认等价于disable

disable validate : 关闭约束,删除索引,不能对表进行 插入/更新/删除等操作.

linux

，
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：phpMyadmin中编辑用户权限Next article：phpMyadmin中隐藏数据库

Related articles

See more