Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Table Size
- Thread starter woodyinoz
- Start date
Hello,
try this good tool:
In the app. there is a funtionality to calculate the table
size or do it with the sql statement:
SELECT NAME, CREATOR, @ROUND(PAGECOUNT/1024,2) As Size
FROM SYSADM.SYSTABLES WHERE SYSTEM = 'N' AND TYPE = 'T' ORDER BY PAGECOUNT DESC
Oliver
try this good tool:
In the app. there is a funtionality to calculate the table
size or do it with the sql statement:
SELECT NAME, CREATOR, @ROUND(PAGECOUNT/1024,2) As Size
FROM SYSADM.SYSTABLES WHERE SYSTEM = 'N' AND TYPE = 'T' ORDER BY PAGECOUNT DESC
Oliver
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question