Listing All Tables of ALL Databases in SQL Server
In this blog we see, How to list all the tables from all the database in sql server.
? – Indicates the name of database.
This will iterate all the database in the sql server and list the sys tables as section based on the database.
sp_msforeachdb 'select "?" AS dbName, * from [?].sys.tables'
You can also use like below,
select * from [DatabaseName].sys.tables
Thanks for reading this article. Have a nice day.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: