# Compareing views create wrong script

**URL:** <https://forums.toadworld.com/t/compareing-views-create-wrong-script/39700>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 14, 2017, 11:17pm UTC](https://forums.toadworld.com/t/compareing-views-create-wrong-script/39700 "2017-07-14T23:17:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![stefan.graf](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@stefan.graf](https://forums.toadworld.com/u/stefan.graf)\
**Post date:** [July 14, 2017, 11:17pm UTC](https://forums.toadworld.com/t/compareing-views-create-wrong-script/39700/1 "2017-07-14T23:17:57Z")

</div>

With the new schema Compare in Toad 12.11.0.95, scripts are created for views with aliases and inner joins, there are missing the alias list.

Example:

Generated diff scrip:

CREATE OR REPLACE VIEW V\_POS  
BEQUEATH DEFINER  
AS  
SELECT wp.REF,wp.ref\_we,we.REF\_LAGER,we.REF\_MAND,a.REF\_SUB\_MAND  
from INCOMING\_POS wp inner join INCOMING we on (we.REF=wp.REF\_WE) inner join ARTICLE a on (a.REF=wp.REF\_AR)

Correct:

CREATE OR REPLACE VIEW V\_PCD\_WE\_POS  
(REF,REF\_WE,REF\_LAGER,REF\_MAND,REF\_SUB\_MAND,REF\_BEST\_POS)  
BEQUEATH DEFINER  
AS  
SELECT wp.REF,wp.REF\_WE,we.REF\_LAGER,we.REF\_MAND,a.REF\_SUB\_MAND  
from INCOMING\_POS wp inner join INCOMING we on (we.REF=wp.REF\_WE) inner join ARTICLE a on (a.REF=wp.REF\_AR)

Is this an error or is there an option to choose?

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [July 20, 2017, 1:23am UTC](https://forums.toadworld.com/t/compareing-views-create-wrong-script/39700/2 "2017-07-20T01:23:02Z")

</div>

Hi,  
From mine point, and that what you shown, those are **not the same** views.  
I saw several bugs in newest Toad version in schema compare…  
Brg  
Damir

---

<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:** [July 25, 2017, 2:44pm UTC](https://forums.toadworld.com/t/compareing-views-create-wrong-script/39700/3 "2017-07-25T14:44:11Z")

</div>

Looks like the view column option was missed in the new schema compare. I’ll add it.

---

<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:** [July 25, 2017, 2:44pm UTC](https://forums.toadworld.com/t/compareing-views-create-wrong-script/39700/4 "2017-07-25T14:44:48Z")

</div>

It’s not something set in the GUI, by the way…it should “just work”.
