Microsoft Dot Net Master
Microsoft Dot Net Master
Monday, April 25, 2011
Find the total number of table in a Database
select
count
(*) from
information_schema.tables
where table_type =
'base table'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment