× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2017-07-31T06:24:10Z  · tomconrad last modified 2018-03-12T00:24:03Z

Primary key/foreign key comment option is disabled in Alter table GUI.


Dev
Sachin Prakash
SachinPrakash
QA
Tariq Rahiman
tariqrahiman
Priority Minor
Complexity Unknown
Component DB - Sybase IQ
Version Future - PM
Product: Aqua Data Studio
Version: 19.0.0-beta-27
Build #: 55332
Build Date: 2017-Jul-30 09:57:53 PM
 
Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_131-b11
Memory: Max=704,643,072;  Total=509,607,936;  Free=245,188,040;  CPUs=4
 
Connect Syabse IQ16.0 with jconnect or ianywhere driver.
 
CREATE TABLE DBA.tab_comment  ( 
EmployeeID   integer NOT NULL,
ManagerID    integer NULL,
Surname      varchar(20) NOT NULL,
GivenName    varchar(20) NOT NULL,
DepartmentID integer NOT NULL,
PRIMARY KEY(EmployeeID) IN iq_main
)
IN iq_main
GO
ALTER TABLE DBA.tab_comment
ADD CONSTRAINT fk_comment
FOREIGN KEY(ManagerID)
REFERENCES DBA.tab_comment(EmployeeID) IN iq_main
GO
COMMENT ON FOREIGN KEY DBA.tab_comment.fk_comment
IS 'Comment on foreign'
GO
COMMENT ON PRIMARY KEY ON DBA.tab_comment
IS 'Comment on primary key'
GO
 
 
 
Steps-01:
Go to table tree node
Right click on DBA.tab_comment  and select alter table option
Alter table window opens
Switch to constraint tab
Select Primary key or foreign key.
Go to constraint detail Pane
 
Actual result:
You can see that,Primary key comment or foreign key comment option is disabled.
 
Expected Result:
Primary key comment or foreign key comment option should be enabled.
 
Observation:
I have executed below script and go to Alter table->Constraint tab
=>You can see that constraint comment is updated successfully.
 
COMMENT ON FOREIGN KEY DBA.tab_comment.fk_comment
IS 'Comment on foreign_updated'
GO
COMMENT ON PRIMARY KEY ON DBA.tab_comment
IS 'Comment on primary key_updated'
GO
 

 

1 attachment
  •  
  •  
  • No shares
  •  
All Comments (2) Change History
Sort 

Issue #15406
New
 
 
Completion
No due date
No fixed build
No time estimate

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