Dec 6, 2003 #1 dbinfoweb Technical User Nov 20, 2001 59 US Is there a query that I can use to check sizes of tables in Sybase?
Dec 8, 2003 #2 grega Programmer Feb 2, 2000 932 GB Use the stored procedure sp_spaceused, i.e. sp_spaceused tablename Greg. Upvote 0 Downvote
Dec 9, 2003 #3 JeanNiBee Programmer Mar 28, 2003 126 US 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 Upvote 0 Downvote
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
Dec 10, 2003 Thread starter #4 dbinfoweb Technical User Nov 20, 2001 59 US Great! Thanks for all your assistances and insights. This really helps. Upvote 0 Downvote