Does D1 supports ALTER COLUMN, ADD CONSTRAINT and so on?

Developers D1
1

For Workers & Pages, what is the name of the domain?

no

What is the issue or error you’re encountering

According the sqlite3 manual SQL Features That SQLite Does Not Implement, alter column data type, constraints is omitted. Does D1 supports alter column data type or changing column constraints? If not, How does wrangler do the migration when column data type is changed?

2

As far as I know, SQLite and therefore D1 doesn’t support these functions, no. If you want to alter a column other than renaming it, you have to REMOVE COLUMN, and then ADD COLUMN.

If you can share your schemas, we can best advise for how to accomplish what you’re trying to do.

1 Like
3

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.