Get the information of database in sql

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