Get list of databases from SQL Server
Get list of databases from SQL Server
Get list of databases from SQL Server
Re: Get list of databases from SQL Server
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
```
`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
```