Table editor fails to create Foreign key.
--Referenced table having Primary key
CREATE TABLE AQM_STR
( PK_STR NUMBER(9,0) NOT NULL,
MUTABLE BOOLEAN INVISIBLE DEFAULT TRUE,
STR1NG VARCHAR(4000) NOT NULL,
CONSTRAINT PK_STR PRIMARY KEY(PK_STR)
);
/
--Attempt to create Foreign key on this table
CREATE TABLE AQM_PRV
(
PK_PRV NUMBER(9,0) NOT NULL,
FK_STR VARCHAR2(256),
CONSTRAINT PK_PRV PRIMARY KEY (PK_PRV)
);
/
Table_editor, shows both columns: “Referenced constraint”
“Associations”. The Referenced column is populated. The "Local Column" drop-list is not populated.
Cannot select column AQM.PRV . FK_STR to reference the AQM_STR . PK STR
3/1/2026, 12:37:04 PM
-------------------------------------------------------------------------------------------
ALTER TABLE NEO.AQM_PRV
ADD CONSTRAINT AQM_PRV_FK1 FOREIGN KEY
(
-- Error: A Foreign Key must define at least one column
)
REFERENCES "NEO"."AQM_STR"
ON DELETE CASCADE
NORELY ENABLE VALIDATE
Absent is the target column name PK_STR → REFERENCES "NEO"."AQM_STR"
Version: 1.109.5 (user setup)
Commit: 072586267e68ece9a47aa43f8c108e0dcbf44622
Date: 2026-02-19T19:43:32.382Z
Electron: 39.3.0
ElectronBuildId: 13313481
Chromium: 142.0.7444.265
Node.js: 22.21.1
V8: 14.2.231.22-electron.0
OS: Windows_NT x64 10.0.26200