[sqlite] How to get length of all columns in a table

[Simon Slavin]

On 1 Jun 2015, at 4:45pm, Drago, William @ CSG - NARDA-MITEQ <William.Drago at 
L-3com.com> wrote:

Just to confirm, the following is the only practical way to get the length of 
each column in a table:
> 
> Select Length(col_1)
> ,Length(col_2)
> ,Length(col_3)
> .
> .
> .
> ,Length(col_n)

Martin's other answer will probably give you the answer faster:

SELECT length(col_1||col2||col_3 ... col_n) FROM MyTable

Simon.