How to renaming a sqlite table programatically in iphone?
SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table, to rename a column within a table, or to add a new column to an existing table.
The RENAME TO syntax changes the name of table-name to new-table-name. This command cannot be used to move a table between attached databases, only to rename a table within the same database. If the table being renamed has triggers or indices, then these remain attached to the table after it has been renamed.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
NSString *querystring ="ALTER TABLE GlossaryRelation_Temp RENAME TO GlossaryRelation "; [self updateStatus:querystring]; -(void)updateStatus:(NSString *)queryString { NSString *docsDir; NSArray *dirPaths; dirPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); docsDir = [dirPaths objectAtIndex:0]; strDatabasePath = [NSString stringWithString:[docsDir stringByAppendingPathComponent:database name]]; NSFileManager *filemgr = [NSFileManager defaultManager]; if ([filemgr fileExistsAtPath: strDatabasePath] == YES) { const char *dbpath = [strDatabasePath UTF8String]; if (sqlite3_open(dbpath, &sqlDatabase) == SQLITE_OK) { const char* beginString = "BEGIN;"; sqlite3_stmt *compiledstatement; sqlite3_prepare_v2(sqlDatabase, beginString, -1, &compiledstatement, NULL); if (sqlite3_step(compiledstatement) == SQLITE_DONE) {} else NSLog(@"Failed!"); sqlite3_finalize(compiledstatement); NSLog(@"QUERY : %@",queryString); const char *selectStatement = [queryString UTF8String]; sqlite3_prepare_v2(sqlDatabase, selectStatement, -1, &compiledstatement, NULL); if (sqlite3_step(compiledstatement) == SQLITE_DONE) {} else NSLog(@"Failed!"); sqlite3_finalize(compiledstatement); const char* endString="END;"; sqlite3_prepare_v2(sqlDatabase, endString, -1, &compiledstatement, NULL); if (sqlite3_step(compiledstatement) == SQLITE_DONE) {} else NSLog(@"Failed!"); sqlite3_finalize(compiledstatement); sqlite3_close(sqlDatabase); } else NSLog(@"Failed to open table"); } } @end |