Wrong answer. He's asking how many bytes a table takes up within the database. That would depend on a whole lot of factors including what is stored, the number of fields, etc.
Is there SQL code to get requested result? Short answer, No. Not easily. Long answer, a table isn't a certain number of bytes. A page is a fixed size, but a page may contain table data, or the page may contain index data, or the page may contain other information. I can't be certain if a single page contains multiple types of data such as table AND index information. The best bet to calculate the number of bytes in a table is to find out what field types you're using in your table, and if variable length strings or blobs are within the dataset, then you need to count each byte for each field for each row, taking in to account unicode if req'd. Then you need to include header information per row and per page for an accurate result. On Wed, Feb 4, 2015 at 1:34 PM, Simon Davies <simon.james.dav...@gmail.com> wrote: > On 4 February 2015 at 18:26, Rael Bauer <supp...@bauerapps.com> wrote: > > Hi, > > > > Is it possible to get the information of how many bytes a table is > taking up > > in the database? > > For Windows, see http://www.sqlite.org/download.html#a10 > There are other links for other operating systems > > > Thanks > > Rael > > Regards, > Simon > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
