How can i compare two schemas db2

Mac OS. Schema sync: All. Data compare: All. Data sync: All. Commercial: Commercial Free. Free edition: All. Connect and share knowledge within a single location that is structured and easy to search. I have been unable to find a solution in my searching for this throughout the web, most responses recommend a tool, which leads me to believe this may be very difficult with an SQL query or something, but I have been told to write a query for our DB2 database, using Toad to interface, that will compare 2 schemas and provide a result if there are any differences.

I know this capability exists in Toad, but for some reason our DBA does not want to use it. Purchasing additional software is not an option. I have not made much progress and am feeling very stuck. Can anyone offer me suggestions? The help is greatly appreciated! I assume by schemas you mean the schemas of a table, right? All that information is available through the views of the syscat schema. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 10 years, 1 month ago. I have not made much progress and am feeling very stuck. Can anyone offer me suggestions? The help is greatly appreciated! I assume by schemas you mean the schemas of a table, right? All that information is available through the views of the syscat schema.