SqlDbx Forum

SqlDbx

You are not logged in.

#1 2015-09-10 08:42:23

timeco
Member

Script object ignores disabled constraints

Hi,

some tables can have constraints that are disabled. When you script those tables, the key-word DISABLE is missing at the end of the scripted constraints, highlighted below:
CONSTRAINT FK_MY_CONSTRAINT FOREIGN KEY  (CUSTOMER_ID) REFERENCES DWH.D_CUSTOMERS (ID) DISABLE,

Is this the intended behaviour? I somehow expected the script to reflect the current state of table / constraints. The environment I use is:
* Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
* SQLDbx 4.10 Professional

Also, do you plan to include table partition info when scripting tables ?

Thank you guys,
Goran

Offline

#2 2015-09-13 21:15:27

sqldbxhelp
Administrator

Re: Script object ignores disabled constraints

Will look into this issue

Offline

Board footer

Powered by FluxBB