Question Locked

how to find largest table(in size) in a database?

0 helpful

2 replies

by theunique1011 Oct 21, 2009 last reply Oct 21, 2009

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all....

Environment:
MS SQL Server Enterprise Edition With SP2

How to find a largest table(in size) in a database?
is there any SQL Command to find it?

How to find the table sizes in ascending or descending order in a database? is there any SQL Command

2 replies

Clarifications

Use the taskpad view on the database. I believe that there is a tab that has tables on it.

This discussion is closed to new replies.