vengatesh Dotnet
Saturday, July 30, 2011
get count of tables from one database
1)Get all the table name from one database
SELECT table_name FROM INFORMATION_sCHEMA.TABLES
2)count how many tables from one database
Select count(table_name) FROM INFORMATION_sCHEMA.TABLES
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment