Count the total number of databases

Question

I am working in SQL server having a large number of databases. I want to count the number of databases. Is there any query to count?

Accepted Answer

```
SELECT * FROM sys.databases

OR

SELECT COUNT(*) FROM sys.databases
```

Solution