MSSQL - Query to list all database names with corresponding ID's

Watch this example on YouTube



Select DB_Name(database_id) as DatabaseName, database_id
From sys.databases;