show databases sql code example

Example 1: mariadb show all databases

SHOW DATABASES;

Example 2: show databases in sql server

SELECT * FROM SYS.DATABASES

Example 3: show databases in sql server

SELECT * FROM SYS.SYSDATABASES

Example 4: show sql server database

EXEC sp_databases

Example 5: show databases in sql server

EXEC SP_DATABASES

Example 6: show databases in sql server

SELECT name FROM master.SYS.DATABASES