Hi Farhad take a look to the ADBOBJECTS() function.

>Dear friends,
>
>How can I get list of tables from a database container? I wana reindex all the tables in a database.
>
>Thank you in advance,
>Farhad Bayanati