title: Athena equivalent to information_schema
body: <p>For background, I come from a SQLServer background and make heavy use of the system tables &amp; information_schema, to tell me all about my tables and columns.</p>
  
  <p>I didn't expect the exact same power in Athena, but currently very shocked and frustrated with what little seems to be available - unless I've missed something ?</p>
  
  <p>For example, 'describe mytable' - just describes 1 table at a time.
  How about showing the columns for ALL tables in one result ?
  It also does not output the table name, nor allow you to manually add that in as a custom column.</p>
  
  <p>All the results of these "show/list/describe" commands seem to produce a text list - not a recordset, so you cannot take the results and join them to other tables or views to make more complex outputs.</p>
  
  <p>Is there any other way to query the contents of my databases ?</p>
  
  <p>Thanks in advance</p>