October 1, 2008 at 7:52 am
how can I find the number of tables in a database???
Is there a system store procudure that does that or do I have to make a query myself???
October 1, 2008 at 7:56 am
Select Count(*) From sys.tables
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 1, 2008 at 9:18 am
Or you can query against the INFORMATION_SCHEMA.TABLES.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply