viewing all tables of the database

Hi,

How can i view all tables in my database ?
I want to see for each table what are the rows and columns.