SqlDbx Forum

timeco

Member

Generate scripts - schema name removal option

Hi,

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
(
    COL_NAME1 NUMBER(1)
)

Is this the intended behavior?

Thx,
Goran

sqldbxhelp

Administrator

Re: Generate scripts - schema name removal option

It's not an intended behavior. It's one of the quirks which we plan to address in a next release