Find the number of tables in Azure SQL Database

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

Table of Contents:


    The query below returns the total number of tables in the current database.

    Query

    select count(*) as [tables]
       from sys.tables 
    

    Columns

    • tables - number of tables in a database

    Rows

    The query returns just one row.

    Sample results

    Those results show that there are 16 tables in the AdventureWorksLT 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