How do I add a new column in between two columns?

by

You have two options.
First, you could simply add a new column with the following:

ALTER TABLE {tableName} ADD COLUMN COLNew {type};

Second, and more complicatedly, but would actually put the column where you want it, would be to create the new table with the missing column and a temporary new name:

CREATE TABLE {tempNewTableName} (name TEXT, COLNew {type} DEFAULT {defaultValue}, qty INTEGER, rate REAL);

And populate it with the old data:

INSERT INTO {tempNewTableName} (name, qty, rate) SELECT name, qty, rate FROM OldTable;

Then delete the old table:

DROP TABLE OldTable;

Then rename the new table to have the name of the OldTable:

ALTER TABLE {tempNewTableName} RENAME TO OldTable;

I’d much prefer the second option, as it will allow you to completely rename everything if need be.

More Related Contents:

  1. How do I rename a column in a SQLite database table?
  2. How do I check in SQLite whether a table exists?
  3. Accessing an SQLite Database in Swift
  4. Import CSV to SQLite
  5. Difference between 2 dates in SQLite
  6. Select random row from a sqlite table
  7. How to get Top 5 records in SqLite?
  8. Insert new column into table in sqlite?
  9. Sqlite primary key on multiple columns
  10. Can SQLite support multiple users?
  11. Export from sqlite to csv using shell script
  12. SQLite: How do I save the result of a query as a CSV file?
  13. Create table in SQLite only if it doesn’t exist already
  14. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  15. SQLITE_BUSY The database file is locked (database is locked) in wicket
  16. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  17. Sqlite over a network share [closed]
  18. SQLite table constraint – unique on multiple columns
  19. Is there a boolean literal in SQLite?
  20. Modify a Column’s Type in sqlite3
  21. Case sensitive and insensitive like in SQLite
  22. svn cleanup: sqlite: database disk image is malformed
  23. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  24. Truncate a SQLite table if it exists?
  25. SQLite for large data sets?
  26. SQLite database supporting Unicode data
  27. Integration Testing Entity Framework code first with in-memory database
  28. How to get the number of rows of the selected result from sqlite3?
  29. How to get the last index of a substring in SQLite?
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment