Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Get list of databases from SQL Server

ayi

<t>Get list of databases from SQL Server</t>

ayi

<t>Execute: 
 
SELECT name FROM master.sys.databases 
 
This the preferred approach now, rather than dbo.sysdatabases, which has been deprecated for some time. 
 
Execute this query:

SELECT name FROM master.dbo.sysdatabases<br/>
<br/>
```<br/>
<br/>
or if you prefer<br/>
<br/>
```<br/>
EXEC sp_databases<br/>
<br/>
```</t>