Create script for multiple FK-Constraints

Toad for Oracle
1

Hi,

when I create a script for multiple FKs Toad creates empty FK-Field brackets in some cases. See this example:

ALTER

TABLE DEF_FTP ADD (

CONSTRAINT DEF_FTP_R01

FOREIGN KEY (HOST_ID)

REFERENCES DEF_FTPHOST (HOST_ID)

DEFERRABLE INITIALLY DEFERRED

ENABLE VALIDATE);

ALTER

TABLE DEF_FTP ADD (

CONSTRAINT DEF_FTP_R02

FOREIGN KEY ()

REFERENCES DEF_FILES_OUTGOING (FLATFILE_ID)

ENABLE VALIDATE);

I select multiple constrains in shema browser and right click create script. It only happens with multiple constraints selected and only on constraint names that have numbers at the end. This is very annoying.

Toad version is Toad for Oracle Professional v 12.1.0.22 (32 bit) on Oracle 11g database.

BR

Nick

2

This is fixed in the current beta.

From: Nicola Wegner [mailto:bounce-Nicola_Wegner@toadworld.com]

Sent: Monday, March 10, 2014 11:49 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Create script for multiple FK-Constraints

Create script for multiple FK-Constraints

Thread created by Nicola Wegner

Hi,

when I create a script for multiple FKs Toad creates empty FK-Field brackets in some cases. See this example:

ALTER

TABLE
DEF_FTP ADD
(

CONSTRAINT DEF_FTP_R01

FOREIGN
KEY (HOST_ID)

REFERENCES
DEF_FTPHOST (HOST_ID)

DEFERRABLE
INITIALLY DEFERRED

ENABLE
VALIDATE);

ALTER

TABLE
DEF_FTP ADD
(

CONSTRAINT DEF_FTP_R02

FOREIGN
KEY ()

REFERENCES
DEF_FILES_OUTGOING (FLATFILE_ID)

ENABLE
VALIDATE);

I select multiple constrains in shema browser and right click create script. It only happens with multiple constraints selected and only on constraint names that have numbers at the end. This is
very annoying.

Toad version is Toad for Oracle Professional v 12.1.0.22 (32 bit) on Oracle 11g database.

BR

Nick

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.