Let's look at some basic operations you might want to do when interacting directly with your database server.
Listing Available Databases
To list those databases available to you when you first connect to a database server, use the following:
Listing Tables in a Database
To list tables available in the currently selected database (USE DatabaseName), use this:
Describing a Table
To see the structure of a table, use this: