Share Knowledge
Thursday, 25 August 2016
How to know the number of tables in a db schema
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'testSchema';
Here "testSchema" is the schema name.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment