create volatile table SIT (s_tablename varchar(30), s_ddl varchar(30000)) on commit preserve rows;
create volatile table UAT (u_tablename varchar(30), u_ddl varchar(30000)) on commit preserve rows;
SELECT TRIM(TABLENAME), 'SHOW TABLE ' || TRIM(TABLENAME) from dbc.tables where databasename='SIT' and tablekind='T' order by tablename;
insert into SIT select trim(tablename), <DDL_OF_TABLE> from dbc.tables where databasename='SIT' and tablekind='T'
and into UAT values as appropriately so that I could LEFT JOIN them as below to find out the differences.
select sit.s_tablename, uat.u_tablename from sit left join uat on sit.s_tablename = uat.u_tablename and sit.s_ddl=uat.u_ddl where uat.u_tablename is NULL;
SEL TABLENAME, COLUMNNAME, COLUMNFORMAT, COLUMNTYYPE, COLUMNLENGTH, NULLABLE,
DECIMALTOTALDIGITS, DECIMALFRACTIONALDIGITS FROM DBC.COLUMNS WHERE DATABASENAME='SIT'
ORDER BY TABLENAME, COLUMNNAME
I think all of the information you need is located in dbc tables. Just skip the excel spreadsheet, the results will return descrepencies
and TD won't blink at 187000 rows.
Sel * from dbc.columns where databasename = 'SIT_dbs'
Sel * from dbc.columns where databasename = 'UAT_dbs;
Sel * from dbc.indices where databasename = 'SIT_dbs'
Sel * from dbc.indices where databasename = 'UAT_dbs';