Here is a link to a document describing the "COMMENT" syntax
http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_4009.htm#i2119719
On Thu, May 29, 2014 at 10:34 AM, Domingo Alvarez Duarte <mingo...@gmail.com
> wrote:
> 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
