Thanks Clemens, that is probably a workable option (at least for me). As someone else noted, the PRAGMA user_version will not work for us as it is one value per db file and we want to set this per table.
Cheers, Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: http://www.ward-analytics.com Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United Kingdom, GU1 3SR Registered company number: 3917021 Registered in England and Wales. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Clemens Ladisch Sent: 14 June 2013 15:21 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Feature request: add support for COMMENT statement Alexey Pechnikov wrote: > It's very important to have place to store table metainformation. In > all common DBMSs we can use TABLE/COLUMN COMMENT as meta description > of table but SQLite doesn't support it. SQLite saves comments in table/view/index/trigger definitions: sqlite> create table t(x /* :-) */); sqlite> .schema CREATE TABLE t(x /* :-) */); Regards, Clemens _______________________________________________ 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
