My friend showed me in ORACLE that using DESC Table NAme was showing information about columns of table. But running this command in H2 Database was giving error, Why? and please tell how to use this command in H2? Thanks.
By admin Posted in: Oracle
My friend showed me in ORACLE that using DESC Table NAme was showing information about columns of table. But running this command in H2 Database was giving error, Why? and please tell how to use this command in H2? Thanks.
You must be logged in to post a comment.
©2011 Fave Soft, All rights reserved.
Because DESCRIBE is a command understood only by the SQLPLUS command tool of the Oracle database. It has nothing to do whatsoever with any standard.
Most relational databases provide commands to do the same, but they are of course all different. I have no idea about the H2 database (never heard about it).