Sep 1, 2010 #1 jasonhuibers Programmer Joined Sep 12, 2005 Messages 290 Location CA I need a query that can count the number of tables in a database?
Sep 1, 2010 1 #2 RiverGuy Programmer Joined Jul 18, 2002 Messages 5,011 Location US SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES Upvote 0 Downvote
Oct 6, 2010 #3 JarlH Programmer Joined Jul 26, 2002 Messages 365 Location SE Note that INFORMATION_SCHEMA.TABLES contains both types tables; both base tables and views. And you will only get information about tables you have access rights to. Upvote 0 Downvote
Note that INFORMATION_SCHEMA.TABLES contains both types tables; both base tables and views. And you will only get information about tables you have access rights to.