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

  • February 8, 2017
  • Posted by: user
  • Category: Uncategorized
No Comments

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]