'How do I rename a column with SQLite?

I am using "System.Data.SQLite;". The Dll version is 1.0.103.0.

My sql statement is ALTER TABLE main.[Resistors] RENAME [Manufacturer Part Number] to [Manufacturer Part Number 1]; The error message I get is "Message=SQL logic error or missing database"

I have also tried ALTER TABLE [Resistors] RENAME COLUMN [Manufacturer Part Number] to [Manufacturer Part Number 1]; Which returned "SQL logic error or missing database near "COLUMN": syntax error"

and tried ALTER TABLE main.[Resistors] RENAME COLUMN [Manufacturer Part Number] to [Manufacturer Part Number 1]; Which returned "SQL logic error or missing database near "COLUMN": syntax error

I'm assuming I need to change "main." to something else but I don't know what it should be. Or I need to update my SQLite. I'm working on that.

system.data.sqlite

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'How do I rename a column with SQLite?

Sources

Related Questions