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