On 15 Mar 2017, at 2:30pm, PICCORO McKAY Lenz <[email protected]> wrote:
> so can introduce a feature that converts all parts that have COMMENT '(\*)'
> to /* COMMENT */ and stored? in the master part of the Database?
It is unlikely that this will happen in SQLite3. What Brian is telling you is
that /you/ can recall the command made to create the table, and parse comments
in it yourself. To get a list of all tables in the database, use the following
SELECT command:
SELECT name,sql FROM sqlite_master
WHERE type='table'
ORDER BY name;
To get the CREATE command for a particular table use
SELECT sql FROM sqlite_master
WHERE name='MyTable';
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
