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