On 2016/09/08 4:59 PM, Stephen Chrzanowski wrote:
Is there a way that I can get your sub-query (Reordered to have tables,
then indexes, then views) to come out as one row? I can then have the
application just do an easy string comparison, AND have a method to include
the resource string to create a new DB (FILE>NEW) in one go.
Bundle into one string while removing all white-space and case-only
differences - this is almost like a hash in SQL terms:
SELECT GROUP_CONCAT(upper(replace(replace(replace(replace(S.sql,'
',''),CHAR(09),''),CHAR(10),''),CHAR(13),'')),' ')
FROM (
SELECT sql
FROM sqlite_master
WHERE sql IS NOT NULL
ORDER BY sql
) AS S
;
A schema would need to have a real change to look different to this query.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
