The below SQL snippet will return a count of the number of tables in a database.

Make sure to change the “use” statement to the required database name