List tables in Azure SQL Database

Rene Castro - Dataedo Team Rene Castro 2018-10-05

Table of Contents:


    The query below lists all tables in an Azure SQL Database.

    Query

    select schema_name(t.schema_id) as schema_name,
           t.name as table_name,
           t.create_date,
           t.modify_date
    from sys.tables t
    order by schema_name,
             table_name;
    

    Columns

    • schema_name - name of the schema
    • table_name - name of the table
    • create_date - creation date of the table
    • modify_date - last modification date of the table by using an ALTER statement

    Rows

    • One row: represents one table in the database
    • Scope of rows: all tables in the database
    • Ordered by: schema and table name

    Sample results

    You could also get this

    Get this interactive HTML data dictionary in minutes with Dataedo.

    See live HTML data dictionary sample

    Try for free

    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 (updated 28-04-2020).
    Accept