Still doesn't work when saving directly to file. Nice
though. Modified version follows. Thanks.
danap.
Fixes/Adds:
1. Header comment added --.
2. Added drop IF EXISTS.
3. Each CREATE VIEW added space after AS.
4. Placed end of statement semicolon directly after parenthesis.
5. Has only \n for
>boun...@mailinglists.sqlite.org] On Behalf Of R Smith
>Sent: Wednesday, 15 August, 2018 03:55
>To: sqlite-users@mailinglists.sqlite.org
>Subject: Re: [sqlite] The upcoming alter table rename column
>
>On 2018/08/15 8:03 AM, Domingo Alvarez Duarte wrote:
>> Hello Richard !
>&
In case anyone followed this topic, it was noted to me off-list that I
included a mistake in the SQL posted, which might confuse people who try it!
Please see below the corrected version.
Cheers!
-- Schema Info Views
--
-- This is a set of views that supply queryable Schema information for
> On Aug 15, 2018, at 11:55 AM, R Smith wrote:
>
> This has been existing for quite a while in SQLite, and not only this, but
> quite a few schema enumeration functions via the table-valued-function form
> of the pragmas.
FWIW, information_schema would be the relevant ANSI-standard in that
On 2018/08/15 8:03 AM, Domingo Alvarez Duarte wrote:
Hello Richard !
I'm following the changes you are making to a add "alter table rename
column" capability to sqlite and I think that it's a good moment to
add a new system table for the columns (I know that we can somehow get
this info now
>boun...@mailinglists.sqlite.org] On Behalf Of Wout Mertens
>Sent: Wednesday, 15 August, 2018 00:33
>To: SQLite mailing list
>Subject: Re: [sqlite] The upcoming alter table rename column
>
>You can, since 3.16, get most pragma results as table-valued
>functions. I
>think what you want is s
You can, since 3.16, get most pragma results as table-valued functions. I
think what you want is something like
SELECT * FROM pragma_table_info("tableName");
On Wed, Aug 15, 2018 at 8:04 AM Domingo Alvarez Duarte
wrote:
> Hello Richard !
>
> I'm following the changes you are making to a add
Hello Richard !
I'm following the changes you are making to a add "alter table rename
column" capability to sqlite and I think that it's a good moment to add
a new system table for the columns (I know that we can somehow get this
info now with "pragmas") this way we can get/use this info
8 matches
Mail list logo