Uncategorized

List All Databases, Objects, Tables by A Simple Single Line Query.

By user · February 8, 2017 · 1 min read

Try below query and see all databases and objects get listed in sql server.

[code:sql]sp_msforeachdb ‘select "?" AS db, * from [?].sys.tables’;[/code]

More on Uncategorized.