How To Describe a Table in H2 Database

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

Tagged: , , , ,

2 thoughts on “How To Describe a Table in H2 Database

  1. L. Sankaranarayanan 11/15/2015 at 2:36 pm Reply

    Thank you very useful
    LS.Sir

    • KNIGHT MASTER 12/13/2015 at 6:56 pm Reply

      glad to help you

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: