SQL Server could not find stored procedure 'show'

Question

I can't use the most basic procedure, show, as it throws an error:

Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'show'.

I used:

SHOW DATABASES

Please help me find answers to this issue.

That's a MySQL-specific command. It doesn't work with SQL Server. — Blorgbeard, Jun 30 '16 at 22:08
Here is how to do that in SQL Server: http://stackoverflow.com/questions/147659/get-list-of-databases-from-sql-server — Blorgbeard, Jun 30 '16 at 22:10

score 11 · Answer 1 · answered Jul 01 '16 at 05:06

11

To list all Databases in SQL Server,

Select * from sys.databases

To exclude in-built DBs,

Select * from sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb');

answered Jul 01 '16 at 05:06

SharK

score 0 · Answer 2 · answered Jul 01 '16 at 11:31

0

Try to refresh local Cache which is under the Intellisense.

answered Jul 01 '16 at 11:31

Jason Clark

2 Answers2