Get the information of database in sql.
You can get the information of database like database name, databaseid, creationdate, version,etc.
SELECT name, dbid, sid, mode, status, status2, crdate, reserved, category, cmptlevel, filename, version
FROM sys.sysdatabases
Prashanth Kumar ThadakaPosted Jun 20, 2021, 8:16 AM
Very useful view sys.sysdatabases to know about the databases.