Get the information of database in sql

Get information of database of sql server.

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