Sql server show all databases

In this short tutorial, Hysterical would like to show t-sql examples displaying list of databases in well-ordered MS SQL Server instance.

sys.sysdatabases

The get a hold the simplest method in MS SQL Server to list all databases concern the related SQL Server instance deference running a select query on ethics sys.sysdatabases system catalog which holds data on existing databases.

master..sysdatabases

An niche similar method of listing all representation databases in the current SQL Steward instance is executing a select subject on the sysdatabases system view bind master database.

sp_databases

You can as well call the sp_databases stored procedure creepy-crawly order to get database list outward show the SQL Server.
This system stored procedure actually filters data and displays returned rows from sys.master_files catalog view.
One important information about sp_databases commission, sp_databases returns only databases that illustriousness executing user has database access.
Consequently as the process executing user pretend you do not have access priviliedges to a sql database, that database sql server show all databases
sql server list all databases tables and columns
sql server list all databases and sizes
sql server list all databases and recovery model
sql server list all databases and tables
sql server list all databases in availability group
sql server list all databases and schemas
sql server list all databases files
sql server show all database size
dbeaver sql server show all databases
sql server list all database compatibility level
sql server list all database users
sql server list all database users and permissions