Alter table not working

  • Resolved jkacher

    (@jkacher)


    5 months, 3 weeks ago

    I wrote about this before, now I have a sample.
    When converting varchar to text, using the Designer, it cannot do it.
    Its Alter table text is
    ALTER TABLE pictures MODIFY COLUMN description text NULL DEFAULT ”NULL”
    The code work in SQL if I remove the last two words DEFAULT ”NULL”

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    5 months, 3 weeks ago

    Hi @jkacher,

    Thanks for the post.

    Do you see an error message when you tried to alter using the Data Designer?

    We tested it just now and it worked or us. Here’s our test: https://share.zight.com/mXuOJ7Oj

    Could you check if there was a default value in the column you tried to alter? Could you try removing that before clicking the Alter button?

    Let us know how it goes. 🙏

    Plugin Contributor Kim L

    (@kimmyx)

    4 months, 2 weeks ago

    Hi there,

    I’m going to mark this as resolved as we haven’t heard from you in a while.

    Feel free to create a new thread if you have other questions.

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.