How can I display a list containing all the tables of all the database in a SQL Server 2008 R2 server?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
You need a query for each database against
You can use
I think it's also worth noting the PowerShell/SMO way to do this. This is one of those requirements that could be quite painless with PowerShell, and definitely the easiest approach if you need to gather this data across multiple servers:
You can use the
protected by Paul White♦ Oct 9 '15 at 15:55
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?