Microsoft SQL Server - select tables using transact sql

by
Jeremy Canfield |
Updated: June 30 2021
| Microsoft SQL Server articles
The select * from information_schema.tables command can be used to return the list of tables in a database. In this example, the tables in database db001 will be displayed.
use db001; select * from sys.databases;
Something like this should be returned.
foo
bar_tbl
tbl001
Did you find this article helpful?
If so, consider buying me a coffee over at