HOW TO GET A LIST ALL DATABASES?

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
 1075  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    How to get a list all databases?

    we get a list of all databases on the server by query the "sys.databases"

    for example

    SELECT name, database_id FROM sys.databases

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!