thnks for help but now i need to modify the same query this query only shows the tables from one database but i need it to run across different database plz suggest the same.