× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swissarmyknife(*) reported 2013-10-31T17:14:49Z  · last modified 2013-11-06T23:55:08Z

Visual Editor - Create Table - making primary keys and foreign keys, the foreign keys ON DELETE and ON UPDATE not included for all foreign keys


customer request
Dev
Ivan Gron
ivangron
QA swissarmyknife(*)
Priority Low
Complexity Unknown
Component App - Visual Editing
Version 14.0

MS SQL Server ( my example is within SQL Server 2008 R2 )

When creating a table in the Visual Editor, and  making primary keys and foreign keys, the foreign keys ON DELETE and ON UPDATE isn't being included in all Foreigh Keys if there is more than one Foreign Key.

However, if you navigate back to the Foreign Keys and change them, the ON DELETE and ON UPDATE will appear in the Preview Pane appropriately for all keys.

 

1. Launch Create Table Visual Editor

2. Create some columns in the General Tab

3. Go to the Constraints Tab and add
a Primary Key
a Foreign Key (set ON DELETE and ON UPDATE CASCADE in Constraints Details)
a second Foreign Key (set ON DELETE and ON UPDATE CASCADE in Constraints Details)

4. View the SQL Preview
only one of your 2 foreign keys will indicate the ON DELETE and ON UPDATE CASCADE

See attached screenshots and GIF Animation

 

 

4 attachments

Issue #10668

Closed
Fixed
Resolved 2013-11-04T18:27:01Z
 
 
Completion
No due date
Fixed Build v14.0.3-16
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017