Get the current schema out of a SQLite database..

read_schema.m

- (NSString *)schemaFor:(NSString *)dbFile
{
    sqlite3 *db;
    NSString *query = @"select name, sql from sqlite_master where type = 'table'";
    NSString *result;
    
    if (sqlite3_open([dbFile UTF8String], &db) == SQLITE_OK) {
        sqlite3_stmt *stmt;
        if (sqlite3_prepare_v2(db, [query UTF8String], -1, &stmt, NULL) == SQLITE_OK) {
            if (sqlite3_step(stmt) == SQLITE_ROW) {
                result = [NSString stringWithUTF8String:(char *)sqlite3_column_text(stmt, 1)];
            }
        }
        
        sqlite3_finalize(stmt);
        sqlite3_close(db);
    }
    return result;
}