SQLIte column edit [Jan 20]

Discord-Discussions
1

:raising_hand_man: dittorahmat asked

How do I edit column type in SQLite ? I want to change a column type to URL. It should be possible looking from the docs

https://docs.nocodb.com/setup-and-usages/tables

However, I can only rename it. The rest was showing warning “This spreadsheet is connected to an SQLite DB. For production please see .”

I’m using this for a small project with 1 table only, so deploying mysql db might be an overkill.

2

:man_technologist: pranavxc replied

SQLite only supports limited support of alter table statement … so in order to avoid problem while altering column type we are disabled column edit option in SQLite

3

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs