List databases in Azure SQL Database

Rene Castro - Dataedo Team Rene Castro 2018-12-10

Table of Contents:


    The query below lists the databases in Azure SQL Database.

    Query

    select [name] as database_name,
        database_id,
        create_date
    from sys.databases
    order by name
    

    Columns

    • database_name - name of the database
    • database_id - database id, unique within an instance of Azure SQL Database
    • created_date - date the database was created or renamed

    Rows

    • One row: represents one database
    • Scope of rows: all databases in Azure SQL Database, including the system database
    • Ordered by: database name

    Sample results

    View of databases in Azure SQL Database. Blue rectangle selects the system database.

    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy.
    Accept