# Toad Schemas or Multiple schemas compares

**URL:** <https://forums.toadworld.com/t/toad-schemas-or-multiple-schemas-compares/27712>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [November 18, 2013, 12:04pm UTC](https://forums.toadworld.com/t/toad-schemas-or-multiple-schemas-compares/27712 "2013-11-18T12:04:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ServiceAccount\_Toad](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@ServiceAccount\_Toad](https://forums.toadworld.com/u/ServiceAccount_Toad)\
**Post date:** [November 18, 2013, 12:04pm UTC](https://forums.toadworld.com/t/toad-schemas-or-multiple-schemas-compares/27712/1 "2013-11-18T12:04:41Z")

</div>

In Database\Compare\Schemas or Database\Compare\Multiple Schemas … is there a way to exclude the actual schema name from comparison? I have 2 different schemas to compare (MXPRD and MAXIMO), and the views kick out as diffs because the schema names differ only. The application team requested different schema names and surely there shouldbe a way to exclude them from the comparison.

Thanks for your time.

---

<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:** [November 18, 2013, 12:12pm UTC](https://forums.toadworld.com/t/toad-schemas-or-multiple-schemas-compares/27712/2 "2013-11-18T12:12:47Z")

</div>

That shouldn’t be a problem unless you have the schema name somewhere inside of the view definition (such as ‘create view blah as select columns from SCHEMA.table’).

Is that what you mean? We don’t have an option to parse those schema names out of the view definition, but they shouldn’t be needed either.

On the other hand, if you are talking about having the schema name before the view name, as in “create view SCHEMA.view as…”, the schema compare won’t flag that as a difference between the views, but it may show up in the side by side viewer if the schema compare flags the view for some other difference.
