How to see a structure of a database

You can type the following to see the structure of a database: DESCRIBE databasenamehere; and this would show you all the tables in it