title: Oracle : which SQL command to get all details about a table?
body: <p>I am developing an Oracle database schema visualizer. So, as a first step, I thought, I will first need to get all the schema details (tables and relationships between tables, constraints also maybe).</p>
  
  <p>To get that information, what is the SQL command that will return the result?</p>
  
  <p>(the <code>DESCRIBE</code> command does not return the information about the all the table)</p>
  
  <p><strong>EDIT #1</strong>:</p>
  
  <p>Actually, what I want to do is to get all the information about all tables as I mentioned (columns, rows, foreign keys, constraints) to store them ina MongoDB database, and then create visualizations (diagrams are not included)</p>