To find how many databases in SQL Server.
There are ways to identify databases in any version SQL Server.
Using SQL Server Management Studio.
Connect any instance of SQL Server Engine and expand the Object Explorer ->Databases.
Here we can see all user created databases.
Connect to the SQL Server Engine. Select New Query option from standard bar.
- List of all databases and its column properties of in an Instance:
select * from sys.sysdatabases.
2. Select specific columns of all databases in an instance.
select name,dbid,cmptlevel from sys.sysdatabases.
In this case we can list out database name, database id, compatibility of all databases in an instance.