Contact Us

Let us know to help you out quickly!

 Admin User     Feb,08 2017

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

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

sp_msforeachdb 'select "?" AS db, * from [?].sys.tables';