How to check SQLite table is empty or not in objective c

Question

I want to check specified table contains value or its empty. I used number of complex method to find but no luck, any body can help me.

Answer 1

NSString *sql2 = SELECT COUNT(*) FROM `myTable`;

If the result is 0 that means table is empty.

if (sqlite3_open([self.dataBasePath UTF8String], &articlesDB) == SQLITE_OK)
    {
        const char* sqlStatement = "SELECT COUNT(*) FROM MYTABLE";
        sqlite3_stmt *statement;

        if( sqlite3_prepare_v2(articlesDB, sqlStatement, -1, &statement, NULL) == SQLITE_OK )
        {
            while( sqlite3_step(statement) == SQLITE_ROW )
            {
                NSInteger count = sqlite3_column_int(statement, 0);
                NSLog(@"Rowcount is %d",count);
            }
        }
        else
        {
            NSLog( @"Failed from sqlite3_prepare_v2. Error is:  %s", sqlite3_errmsg(articlesDB) );
        }
        sqlite3_finalize(statement);
        sqlite3_close(articlesDB);
    }