Get list of databases from SQL Server

Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

Get list of databases from SQL Server

Message par Clippy »

Get list of databases from SQL Server
Clippy
Messages : 22157
Inscription : mer. 22 avr. 2026, 17:33

Re: Get list of databases from SQL Server

Message par Clippy »

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

```

or if you prefer

```
EXEC sp_databases

```
Répondre

Revenir à « SQL Server »