由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - disable constraint
相关主题
请教constraintsHelp on MS SQL code
谁知道下面这段是什么意思(ABOUT CONSTRAINTS)学MIS 还是统计?
another question--怎么delete a row from a tablewhat's wrong with this table sql syntax?
No Need for trigger Re: oracle trigger questiona oracle question
How to find primary keycan't disable a constraint
PL/SQL constraint 求教?truncate和delete在ORACLE里有什么区别?
Re: have a simple question. Please helphow to store a trie into database?
Help!!! constraint in inputting datawhich sys sp (sql server) show all user sp and functions?
相关话题的讨论汇总
话题: diable话题: disable话题: constraint话题: tables
进入Database版参与讨论
1 (共1页)
a***o
发帖数: 22
1
I have a lot of constraints mounted with my tables. Before I exported data
into those tables, I'd like to diable all of the constraints at the same time.
does anybody have good method to diable all of the constraints at the same time
and then enable them after exporting. thanks in advance.
b****e
发帖数: 1275
2
use TOAD.. just one click.. i don't know the sql that would disable all
in one statement though

【在 a***o 的大作中提到】
: I have a lot of constraints mounted with my tables. Before I exported data
: into those tables, I'd like to diable all of the constraints at the same time.
: does anybody have good method to diable all of the constraints at the same time
: and then enable them after exporting. thanks in advance.

1 (共1页)
进入Database版参与讨论
相关主题
which sys sp (sql server) show all user sp and functions?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
oracle load数据怎么会这么慢?Help!!! constraint in inputting data
请教constraintsHelp on MS SQL code
谁知道下面这段是什么意思(ABOUT CONSTRAINTS)学MIS 还是统计?
another question--怎么delete a row from a tablewhat's wrong with this table sql syntax?
No Need for trigger Re: oracle trigger questiona oracle question
相关话题的讨论汇总
话题: diable话题: disable话题: constraint话题: tables