var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to compare two table layout
We have 4 different schema in same database, all schema contains similar table structures but we have found some layout differences in some of table.
Is there any command which compare table layout of same table from two difference schema?
This is for DB2 9
Optim Database Administrator has this feature I believe. Possibly Toad as well - check their web site.
ODA had this option Select the schema and right click on it you have option compare schema.
Quest Toad for db2, DBARTISA's Change manager has this option.
Or you can use db2look to generate DDL for different schemas and then do a "diff" on them.
Thanks for reply...Currently we don't have Toad or any other tool... but getting table ddl and doing diff can give me answers..
Thanks for your quick reply...