011. Get all available Databases in SQL Server Instance

Get all available Databases in SQL Server Instance

select [name] as database_nane, 
    database_id, 
    create_date
from sys.databases
order by name

 

Sample Output:

Get All available Databases in SQL Server Instance-image
Get All available Databases in SQL Server Instance-image

Leave a Reply