由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - can't disable a constraint
相关主题
another question--怎么delete a row from a tableSQL Server Trigger on System Base Table or Catalog View
Help on MS SQL code谁知道下面这段是什么意思(ABOUT CONSTRAINTS)
a oracle questionNo Need for trigger Re: oracle trigger question
truncate和delete在ORACLE里有什么区别?How to find primary key
SQL 2008 Create Index vs Rebuild Index (Alter Index)PL/SQL constraint 求教?
MS SQL怎么加conditional checkRe: have a simple question. Please help
disable constraintHelp!!! constraint in inputting data
请教constraints学MIS 还是统计?
相关话题的讨论汇总
话题: disable话题: constraint话题: table
进入Database版参与讨论
1 (共1页)
e******r
发帖数: 220
1
我想要disable一个constraint,
ALTER TABLE NT
DISABLE CONSTRAINT PK cascade;
但不知道什么原因,去不掉. 请教如何disable?
谢谢
w*******e
发帖数: 1622
2
用NOCHECK就行了

【在 e******r 的大作中提到】
: 我想要disable一个constraint,
: ALTER TABLE NT
: DISABLE CONSTRAINT PK cascade;
: 但不知道什么原因,去不掉. 请教如何disable?
: 谢谢

1 (共1页)
进入Database版参与讨论
相关主题
学MIS 还是统计?SQL 2008 Create Index vs Rebuild Index (Alter Index)
what's wrong with this table sql syntax?MS SQL怎么加conditional check
how to store a trie into database?disable constraint
which sys sp (sql server) show all user sp and functions?请教constraints
another question--怎么delete a row from a tableSQL Server Trigger on System Base Table or Catalog View
Help on MS SQL code谁知道下面这段是什么意思(ABOUT CONSTRAINTS)
a oracle questionNo Need for trigger Re: oracle trigger question
truncate和delete在ORACLE里有什么区别?How to find primary key
相关话题的讨论汇总
话题: disable话题: constraint话题: table