# Create script for multiple FK-Constraints

**URL:** <https://forums.toadworld.com/t/create-script-for-multiple-fk-constraints/29205>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 10, 2014, 9:49am UTC](https://forums.toadworld.com/t/create-script-for-multiple-fk-constraints/29205 "2014-03-10T09:49:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nicola\_Wegner](https://avatars.discourse-cdn.com/v4/letter/n/d2c977/32.png) [@Nicola\_Wegner](https://forums.toadworld.com/u/Nicola_Wegner)\
**Post date:** [March 10, 2014, 9:49am UTC](https://forums.toadworld.com/t/create-script-for-multiple-fk-constraints/29205/1 "2014-03-10T09:49:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [March 10, 2014, 10:04am UTC](https://forums.toadworld.com/t/create-script-for-multiple-fk-constraints/29205/2 "2014-03-10T10:04:52Z")

</div>

This is fixed in the current beta.

**From:** Nicola Wegner [[mailto:bounce-Nicola\_Wegner@toadworld.com](mailto:bounce-Nicola_Wegner@toadworld.com)]

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

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

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

**[Create script for multiple FK-Constraints](http://www.toadworld.com/products/toad-for-oracle/f/10/t/21534.aspx)**

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](http://www.toadworld.com/products/toad-for-oracle/f/10/t/21534.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/21534.aspx?AbuseContentId=5fb02a47-f904-462e-88c2-f2b2aab86ff8&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/o/04j0/fd5df538/32svk0re.gif)