Hi,
We need to periodically check if there is a difference in table structure between two schemas (i.e. Ext and Staging). The table names are the same, but in the staging schema they have an additional prefix: EXT_
Desired output:
Schema_Name Table_Name Column_Name
EXT Address new_column_name
STAGING EXT_ADDRESS null
List only columns that don't match.
Thanks in advance!