Alter table, Show SQL without schema

Toad for Oracle - Beta
1

When displaying the "SQL without schema" in the Alter-Table dialog, the schema name is not omitted for ForeignKey Contraints in the referenced table.

ALTER TABLE TABLE_A
 ADD CONSTRAINT FK_ID_TABLE_B 
  FOREIGN KEY (ID_TABLE_B) 
  REFERENCES SCHEMA.TABLE_B (ID)
  ENABLE VALIDATE;
2

Thanks Dirk. I'll fix. I'm glad someone is using that. :slight_smile:

3

I use that all the time!
So often that I wish there was an option to make that the default. :wink: