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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Size of Table

Status
Not open for further replies.

dbinfoweb

Technical User
Nov 20, 2001
59
US
Is there a query that I can use to check sizes of tables in Sybase?
 
Use the stored procedure sp_spaceused, i.e.

sp_spaceused tablename


Greg.
 
The values reported by sp_spaceused are only as 'fresh' as your last update statistics.

So update, then check the sp_spaceused if you require accurate values. (Or as accurate as sp_spaceused can be).

-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and
Code:
[/ignore] tags.

Ex:
Code:
SELECT 1 from sysobjects

 
Great! Thanks for all your assistances and insights. This really helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top