How to find number of Tables in a DB using T-SQL?

How to find number of Tables in a DB using T-SQL?

SELECT COUNT(*) from information_schema.tables WHERE table_type = 'base table'

No comments: