title: Get table schema or structure in netbeans, derby
body: <p>I've been creating a database in derby/netbeans. And I'd like to output the structure of the database, not just exporting the whole database. How do I do this?</p>
  
  <p>I've tried both "EXEC 'table name';"
  which returned
  "Error code -1, SQL state 42X01: Syntax error: Encountered "exec" at line 1, column 1."
  and 
  "SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'table name';"
  which returned "Error code -1, SQL state 42Y07: Schema 'INFORMATION_SCHEMA' does not exist".</p>
  
  <p>I've read on multiple forums that this should work, do you guys have any idea what I'm doing wrong?</p>