Re: [sqlite] SELECT ALL BUT syntax (was Re: less typing possible ?)

thanks Darren, Darren Duncan wrote: > Stef Mientki wrote: > >> hello, >> >> I often want to see most of the columns of a table / view / query, but a >> few I don't want to see. >> So I now create a huge list of fields, >> but isn't there a more typo-frindly way, like : >> >> select * -

[sqlite] SELECT ALL BUT syntax (was Re: less typing possible ?)

Stef Mientki wrote: > hello, > > I often want to see most of the columns of a table / view / query, but a > few I don't want to see. > So I now create a huge list of fields, > but isn't there a more typo-frindly way, like : > > select * - field33 from table A syntax option introduced in Date