raj.prabhu001 (8/19/2013)
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.
Are you saying you want to run this same script on all databases on your server? This is one of those rare times where a cursor is exactly what you need. One possibility is to use the undocumented sp_msforeachdb. A quick search will present you with examples. The other option is to roll your own cursor with dynamic sql.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/