Query below returns total number of tables in 'Sales' database.

Query

SELECT  COUNT(*) AS Tables
FROM    DBC.TablesV
WHERE   TableKind = 'T'
AND     DatabaseName = 'Sales';

Columns

• Tables - number of tables in a database

Rows

Query returns just one row.

Sample results

Those results show that there are 16 tables in the 'Sales' database.