There is currently no way to add, rename, or drop a column on an existing table except DROP TABLE + CREATE TABLE. dBASE III had MODIFY STRUCTURE (full-screen editor).
Proposal: implement it as an Assistant wizard (src/ui/wizards/) showing the current schema in an editable grid, generating ALTER TABLE statements through ServerDatabaseBridge. SQLite supports ADD COLUMN, RENAME COLUMN, and DROP COLUMN natively (3.35+); type changes need a copy-table dance.
A plain-command fallback like ALTER TABLE <name> ADD <col> <type> would also be welcome as a first step.
There is currently no way to add, rename, or drop a column on an existing table except
DROP TABLE+CREATE TABLE. dBASE III hadMODIFY STRUCTURE(full-screen editor).Proposal: implement it as an Assistant wizard (
src/ui/wizards/) showing the current schema in an editable grid, generatingALTER TABLEstatements throughServerDatabaseBridge. SQLite supportsADD COLUMN,RENAME COLUMN, andDROP COLUMNnatively (3.35+); type changes need a copy-table dance.A plain-command fallback like
ALTER TABLE <name> ADD <col> <type>would also be welcome as a first step.