Winan,
I'm not sure if this is the 'standard' way, but one way is to query the information schema of the database...
select distinct table_name from MyDatabase.Information_schema.columns
That will get you a unique list of tables.
If you want a list of tables and columns...
select table_name,column_name from MyDatabase.Information_schema.columns
Kevin