# Alter table, Show SQL without schema

**URL:** <https://forums.toadworld.com/t/alter-table-show-sql-without-schema/58321>\
**Category:** Toad for Oracle - Beta\
**Created:** [October 16, 2023, 8:44am UTC](https://forums.toadworld.com/t/alter-table-show-sql-without-schema/58321 "2023-10-16T08:44:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dirk.mika1](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dirk.mika1/32/16503_2.png) [@dirk.mika1](https://forums.toadworld.com/u/dirk.mika1)\
**Post date:** [October 16, 2023, 8:44am UTC](https://forums.toadworld.com/t/alter-table-show-sql-without-schema/58321/1 "2023-10-16T08:44:53Z")

</div>

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

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

```

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [October 16, 2023, 12:26pm UTC](https://forums.toadworld.com/t/alter-table-show-sql-without-schema/58321/2 "2023-10-16T12:26:05Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dirk.mika1](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dirk.mika1/32/16503_2.png) [@dirk.mika1](https://forums.toadworld.com/u/dirk.mika1)\
**Post date:** [October 16, 2023, 1:08pm UTC](https://forums.toadworld.com/t/alter-table-show-sql-without-schema/58321/3 "2023-10-16T13:08:32Z")

</div>

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