18 March 2014

How to get total number of tables in a database in SQL?

SELECT COUNT(*) as TotalTables FROM sys.tables WHERE type in ('u')
Posted by at
Labels: , , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)