SqlServer 08: Query to list all databases in an instance?

Question

How do I list all the databases for a given sql server 08 instance using sqlcmd?

Heinzi · Accepted Answer · 2021-07-23 13:58:05Z

54

sqlcmd -E -S SERVER\INSTANCE -Q "sp_databases"

Notes:

-E: Use a trusted connection ("Windows authentication"). Replace by -U username -P password for SQL Server authentication.
-S SERVER\INSTANCE: The instance of SQL Server to which to connect. If you don't know the name of your instance, you can use sqlcmd -L to get a list.
-Q: The query to execute. The uppercase Q causes sqlcmd to exit after executing the query.

edited Jul 23, 2021 at 13:58

answered Jan 18, 2010 at 17:29

Heinzi

173k61 gold badges386 silver badges554 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shaun Luttin · Accepted Answer · 2017-03-23 21:42:53Z

39

To elaborate with more detail for the sqlcmd newbie:

C:\> sqlcmd -S <the_server_name>
1> select name from sys.databases
2> go

answered Mar 23, 2017 at 21:42

Shaun Luttin

143k93 gold badges442 silver badges495 bronze badges

2 Comments

Felix Eve Over a year ago

Where do I find out what the server name is? Is there a command to list all the servers?

Heinzi Over a year ago

@FelixEve: stackoverflow.com/q/141154/87698

D'Arcy Rittich · Accepted Answer · 2010-01-18 17:29:31Z

34

EXEC sp_databases

or

SELECT NAME FROM sys.sysdatabases

or

EXEC sp_msForEachDB 'PRINT ''?''';

answered Jan 18, 2010 at 17:29

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

2 Comments

Dane O'Connor Over a year ago

Up voted for options but accepted Heinzi because it includes the sqlcmd aspect. Thanks!

barlop Over a year ago

I'm a newb and may be stating the obvious here, but I had to do 'go' after the EXEC line like this 1>EXEC sp_databases<ENTER>2>go<ENTER>

Giorgi · Accepted Answer · 2010-01-18 17:30:24Z

3

You can use sp_databases stored procedure.

answered Jan 18, 2010 at 17:30

Giorgi

31k13 gold badges92 silver badges128 bronze badges

Collectives™ on Stack Overflow

SqlServer 08: Query to list all databases in an instance?

4 Answers 4

Comments

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related