Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mohit Nayyar Get all user def table info with rowcount and size RE: Get all user def table info with rowcount and size
Mark Ellis-431978
SSC Journeyman
Points: 85
More actions
November 19, 2007 at 8:00 am
#752295
If you'd like to sort by any of the size columns, simply substitute the following ORDER BY clause with the name of the column inserted. As an example I sorted by dataSpace.
ORDER BY convert(int,reverse(substring(reverse(dataSpace),4,10))) DESC;