The below query will return a list of none system databases on a Microsoft SQL Server;
SELECT name FROM master..sysdatabases WHERE dbid > 4
Or you can run the below to get a list of databases along with their size and remarks;
More information about text formats
There is currently 1 user online.