Page 1 of 1

SQLite3 – Compare 2 tables, list missing columns/fields

SQLite3 – Compare 2 tables, list missing columns/fields

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
Examples: "MacOS X - Your question", "MS Word - Your Tip or Trick".

Please note that switching to another language when reading a post will not work!
Posts will not have a translated counterpart.




RSS Feed

Home Forums Software Development Databases SQLite3 – Compare 2 tables, list missing columns/fields

Viewing 1 post (of 1 total)
  • Author
    Posts
  • 13101

    Hans
    Keymaster

    I had to do some comparing of an old table and a new table, and see what columns (fields) are missing.

    Since it took me quite a while to figure this one out, here my solution.

    I have 2 tables: preferences and preferences_old ….
    The old preferences table is missing some fields that do exist in the new preferences table.

    This SQL query lists this missing columns (works only as of SQLite 3);

    SELECT name FROM pragma_table_info("preferences") 
    WHERE NOT name IN (SELECT name FROM pragma_table_info("preferences_old"));
Viewing 1 post (of 1 total)



You must be logged in to reply to this topic.