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

Post a Comment

Popular posts from this blog

c# - Reactive Extensions ControlScheduler -

Well, I'm using Reactive Extension Event Handler to handle my app events, I run the headlines on the Yuri thread. I also use ControlSubular for However, recently I am getting cross thread exception despite using control scheduler and I do not know what the problem is. Code: Observable.FromEventPattern & Lt; String & gt; (CC, "UiAlertMessage", New Control Session ()) Subscribe (_ = & gt; {Alert Control. (Show this language, title, _.EventArgs.UppercaseFirst ());}); The new control scheduler (this) is not to run the code on the UI control thread, so I do not get cross threading exceptions? you should do Observable.FromEventPattern & lt; String & gt; (CC, "UiAlertMessage"). AboveOption (this). Subscribe (_ = & gt; {Alert Control. (Show this language, Titles, _.EventArgs.UppercaseFirst ());}); This is the standard way of sending a scheduler related to specific controls. Passing control scheduler as you have got subsc...
Read more

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

Is there any way, I can get some parameters from the header, cookies (log in userId in my case) , And then apply it in a form which I know who will deposit the ticket? SupportForm supportForm: form [supportTicket] = form (mapping ("question" -> text, "priority" -> text) (apply support ticket. (HelpText.update) What are the good practices here? What is the call to apply the request, when I can use it (and also a good practice?) Edit An issue, absolutely deceiving anyone if I were to create a hidden area with this value. It could Ript, but the issue may be re-used in any way to verify and return the form, it can not be sure how it ....
Read more

javascript - Enable/Disable form elements and changing the values of button at a time? -

requirement: text is a button with "disabled" when the page opens, then I want to disable it when the user clicks on button , I want to enable my form field and at the same time I want to change the value of my button to "enabled." I have an example of how the button's value, but how can I enable / disable it at the same time? & lt; H: form & gt; Please press this button & lt; H: command button id = "cb1" value = "# {ActionBean.buttonText}" instant = "true" functionalist = "# {ActionBean.processMyAction}" /> & Lt; / H: form & gt; My Bean class looks like this: / * action listener method * / public zeroes process my action (verb phenomenon) {disable =! Disable; System.out.println ("disable:" + disabled); If (buttonText.equals ("disable")) {buttonText = "enable"; System.out.println ("Button Type:" + Button); } Else {buttonText = "disable...
Read more