To drop a column, you need to use the steps above. SQLite does not support ALTER TABLE DROP COLUMN statement. enable foreign key constraint check PRAGMA foreign_keys= on Code language: SQL (Structured Query Language) ( sql ) SQLite ALTER TABLE DROP COLUMN example rename the new_table to the table ALTER TABLE new_table RENAME TO table copy data from the table to the new_table INSERT INTO new_table(column_list) Here you can drop column CREATE TABLE IF NOT EXISTS new_table( The following script illustrates the steps above: - disable foreign key constraint check PRAGMA foreign_keys= off If you want to perform other actions e.g., drop a column, you use the following steps: Using SQLite ALTER TABLE for other actions The following shows the syntax of the ALTER TABLE RENAME COLUMN statement: ALTER TABLE table_nameįor more information on how to rename a column, check it out the renaming column tutorial. SQLite added the support for renaming a column using ALTER TABLE RENAME COLUMN statement in version 3.20.0 Try It Using SQLite ALTER TABLE to rename a column
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |