SHOW ERROR IN SQL

What are you trying to do? Get a list of databases from a server?

Try

SELECT * FROM sys.databases

Select allOpen in new window

"SHOW DATABASES" is for MySQL not SQL server...

SHOW DATABASES Syntax
https://dev.mysql.com/doc/refman/5.7/en/show-databases.html

Well there are N number of ways you can get the list of databases. here are few -

1.

select * from sys.databases

Select allOpen in new window

2.

SELECT * FROM master.dbo.sysdatabases

Select allOpen in new window

3.

EXEC sp_databases

Select allOpen in new window

If you dont want system databases use below-

4.

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

Select allOpen in new window

if you want to use any specific database use like below

USE [databaseName]
GO

E.g.
USE Master
GO

thanku ..

Hey Manish , Do you need more help with this