Finding table size

[guptavinayak]

Hi All,
I need to find the table size of a particular table, I have a valid
Oracle query :
select sum(bytes) from user_segments where segment_name like
'TEST_TABLE' , which returnes the size in byes, I need a similar query
that should work on MS SQL.
Thanks,
Vinayak

 

[Rick B]

Access is a file based database and there is no "table size" per se. You
could make a copy of your file, compact both the copy and the original,
remove the table from the copy, compact again, and compare the sizes of the
two files, but table size is not really applicable to a file-based
application.