How to calculate size of the table in SQL Ce database

Question

Hi,

I am working on .Net application which uses SQL CE compact database. I need to calculate size of the table from the database. I tried to use following

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_TYPE = 'CUST_TAB')

However, i am not able to get size from result of the query executed above. I am using SQL CE 3.5 compact edition. Can anyone please help me to resolve the same ?

Answer 1

Maybe this KB article can help:  http://support.microsoft.com/kb/827968

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog