Advertisement

04.01.2008 at 09:07AM PDT, ID: 23286249
[x]
Attachment Details

Find rowcount of all tables

Asked by chlade in MS SQL Server

Tags: MS, SQL Server, 2000

I am doing research on a SQL Server 2000 table.  Is there an easy way of seeing a list of all tables and the number of rows and columns in each table?  Obviously, I can do this one-by-one but there are over 100 tables so I'm hoping for a quicker and easier method.Start Free Trial
 
Keywords: Find rowcount of all tables
Title
1 Rowcount
2 row to column
3 Best way to update a column for a larg…
4 Rowcount?
5 RowCount
6 Separating PHP Table Row Results
 
Loading Advertisement...
 
[+][-]04.01.2008 at 09:12AM PDT, ID: 21255376

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.01.2008 at 09:12AM PDT, ID: 21255382

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.01.2008 at 09:13AM PDT, ID: 21255398

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.01.2008 at 09:14AM PDT, ID: 21255412

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.01.2008 at 09:19AM PDT, ID: 21255469

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: MS, SQL Server, 2000
Sign Up Now!
Solution Provided By: cmangus
Participating Experts: 5
Solution Grade: A
 
 
[+][-]04.01.2008 at 09:33AM PDT, ID: 21255604

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628