Hello all !
Now that we are talking about comments in sql statements why not extend
sqlite to accept the "COMMENTS" keyword for fields and tables and then we
will have a standard way to store extra information about our sql schema.
Cheers !
On Thu, May 29, 2014 at 10:10 AM, Luuk <luu...@gmail.com> wrote:
> On 29-5-2014 11:00, Dan Kennedy wrote:
>
>> On 05/29/2014 03:42 PM, big stone wrote:
>>
>>> Hello,
>>>
>>> I miss the functionnality of some other sql motors that keep the comments
>>> inside an object definition, like a table.
>>>
>>
> ....
>
>
> This sounds quite illogical, as :
>>> - Newlines and spaces are kept, (if not around a comment)
>>> - the SQLite internal parser would re-parse (and remove comments)
>>> from the
>>> original statement without issue.
>>>
>>
>> I think in practice the text that appears before the first "(" character
>> in the CREATE TABLE statement is replaced by "CREATE TABLE <tblname>".
>>
>
>
> Before the first "(" ???....
>
> C:\temp>sqlite3
> SQLite version 3.8.4.3 2014-04-03 16:53:12
> Enter ".help" for usage hints.
> Connected to a transient in-memory database.
> Use ".open FILENAME" to reopen on a persistent database.
> sqlite> create /* test */ table test(x);
> sqlite>
> sqlite> select * from test;
> sqlite> .schema
> CREATE TABLE test(x);
> sqlite> select sql from sqlite_master;
> CREATE TABLE test(x)
> sqlite>
>
>
>
>
> _______________________________________________
> 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
