diff - Compare two schemas using SQL only in H2 -


I have two schemas in the H2 database: public and test . I have to find out whether the tables in the public and test are similar (same columns with the same data type) and if not, which tables are different so far I I select the required information in INFORMATION_SCHEMA and compare myself using the shell script. But I was wondering if I can use pure SQL for example, for example just select different tables.


Comments

Popular posts from this blog

eclipse plugin - Run java code error: Workspace is closed -

ios - How do I use CFArrayRef in Swift? -

scala - Play Framework - how to bind form to a session field -