Bootstrap FreeKB - Microsoft SQL Server - select tables using transact sql
Microsoft SQL Server - select tables using transact sql

Updated:   |  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 Buy Me A Coffee



Comments


Add a Comment


Please enter 79a909 in the box below so that we can be sure you are a human.