To list all Databases in MSSQL you can use the following snippet.
Sample MSSQL
SELECT name FROM sys.databases
SQL Server Version newer than MS SQL 2000 also support these StoredProcedures.
EXEC sp_databases
or
EXEC sp_helpdb
One thought on “How to list all Databases in MSSQL”
Leave a Reply
You must be logged in to post a comment.
RT @CodeSnippetsNET: How to list all Databases in #MSSQL http://t.co/dokmukg9xT #sql #dev #coding #programming #code