Would this not work for you?
http://stackoverflow.com/questions/7426205/sqlite-adding-comments-to-tables-and-columns
.schema
On 13-06-14 11:00 AM, Dave Wellman wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
