when using Tools -> Generate scripts, and disabling "Include Object Owner / Schema" option, Sqldbx still uses owner/schema names in ForeignKey constraints, for example:
CONSTRAINT FK_DIM_XYZ FOREIGN KEY (COL_NAME1) REFERENCES SCHEMA_NAME.DIM_XYZ (COL_NAME2)
However, it works correctly in simple table scripting (with no foreign key constraints), e.g:
CREATE TABLE DIM_XYZ
Is this the intended behavior?
It's not an intended behavior. It's one of the quirks which we plan to address in a next release