Warning: mysqli_query(): (HY000/1030): Got error 28 from storage engine in /www/wwwroot/shulanxt/wp-includes/wp-db.php on line 2007
Oracle 启用外键 - 树懒学堂
  • 导航

Oracle 启用外键


在Oracle中,面对已经被禁用的外键,我们该如何将它重新启用呢?本教程就为大家带来Oracle外键启用方法。

外键启用语法

ALTER TABLE table_name
ENABLE CONSTRAINT constraint_name;

示例:

我们可以先创建一个名为fk_supplier的外键,然后对这个外键进行禁用

现在,我们将重新启用这个被禁用的fk_supplier外键,可以执行以下命令:

ALTER TABLE products
ENABLE CONSTRAINT fk_supplier;


Warning: mysqli_query(): (HY000/1030): Got error 28 from storage engine in /www/wwwroot/shulanxt/wp-includes/wp-db.php on line 2007
  Oracle 禁用外键
Warning: mysqli_query(): (HY000/1030): Got error 28 from storage engine in /www/wwwroot/shulanxt/wp-includes/wp-db.php on line 2007
Oracle Ascii()函数