-- Delete a column (id)
ALTER TABLE substance DROP id;
-- Add new column (id as Primary Key)
ALTER TABLE substances ADD COLUMN id INTEGER PRIMARY KEY;
-- Note: Column order can NOT be changed.
nihilism is exhausting
-- Delete a column (id)
ALTER TABLE substance DROP id;
-- Add new column (id as Primary Key)
ALTER TABLE substances ADD COLUMN id INTEGER PRIMARY KEY;
-- Note: Column order can NOT be changed.
"This aggression will not stand, man."