Hi there,

Our small company regularly alters tables, creates new views, adds
triggers and sequences, and these changes have to be reciprocated at
out (single) client site. Its hard to keep track, as people forget the
changes they have made, or don't bother to update files of changes.

What's the best way to compare 2 different schemas in a single
database? Something that will tell me things like:

1. This table T1 has a new fields...
2. This table T2 does not exist...
3. This table T3 has a different key...
4. This view is different.
5. This trigger is changed.
6. This sequence is new.
etc....

Thanks for any help,

Dean