Search

Friday, February 22, 2013

Find Number of Tables in a Perticular Database

USE Master
SELECT COUNT(*) from information_schema.tables
 
WHERE table_type = 'base table'
 
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)