H2 database management system has several differences from another DBMS. H2 is build on java programming language. It is fast, simple and very powerful for java program which need database connection. H2 is also become default DBMS for grails framework. Yesterday, i need to see (description) from a table in my program. when i connect into h2 console, i can’t see description of a table through ordinary command “describe table [table_name]”. No, it doesn’t work. As you can see on image below, there is no auto complete for that command.
SYNTAX ERROR COME
I decide to googling, and i found this command “SHOW COLUMNS FROM [TABLE_NAME]”. Finally, it work just like describe in MYSQL.
SUCCESS SHOW COLUMN FOR TABLE