1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

[SQL] Changing the maximum length of a varchar column?

Discussão em 'Outras Linguagens' iniciado por Stack, Setembro 4, 2021.

  1. Stack

    Stack Membro Participativo

    I'm trying to update the length of a varchar column from 255 characters to 500 without losing the contents. I've dropped and re-created tables before but I've never been exposed to the alter statement which is what I believe I need to use to do this. I found the documentation here: ALTER TABLE (Transfact-SQL) however I can't make heads or tails of it.

    I have the following so far (essentially nothing unfortunately):

    alter table [progennet_dev].PROGEN.LE
    alter column UR_VALUE_3


    How do I approach this? Is there better documentation for this statement out there (I did some searches for an example statement but came up empty)?

    Continue reading...

Compartilhe esta Página