View original (French)

Count the tables in the database

christian -  
jee pee Posted messages 31879 Registration date   Status Moderator Last intervention   -

Hello, I am new to data analysis. I would like to know what query we can write to find out the number of tables in a database. Thank you.


1 answer

  1.
    jee pee Posted messages 31879 Registration date   Status Moderator Last intervention   9 978
     

    Hello,

    First, it is preferable to indicate the relevant DBMS. Because the SQL queries could be specific.

    Then we need to look at the scope. The number of tables visible to the connected user, the number of tables visible to the system administrator, and do we want user tables or also the internal management tables specific to the DBMS?

    0