Toad World® Forums

BUG ?! Missing schema name in the foreign keys clause of a generated DDL

The issue:

Toad generates an invalid DDL script for a table that has foreign key constraint and resides in other that the default "dbo" schema.

Take the following two tables:

CREATE TABLE err.table_a (id INT PRIMARY KEY);

CREATE TABLE err.table_b(
id INT, a_id INT CONSTRAINT fk_tablea FOREIGN KEY REFERENCES err.table_a(id));

Then use the table details viewer, script tab to preview the generated code. It doesn't include the schema name in from of the referenced table.

Pay attention to that "Schema qualify" option is checked and works for the table name.

Strangely enough, the code is fine, when you click the "Generate a creation script" button.

Hi,

Sorry for your inconvenience. ToadforSQLServer Team is leaving office from 18th to 25th February. We will check this and keep you update.

Best Regards,

Kelly

Hi,

I reproduce this issue and create TSS-925. We will look at this. Thank you very much.

Best Regards,

Kelly

Hi,

TSS-925 has been fixed. Please try next new beta.

Thank you very much.

Best Regards,

Kelly