Alterar o tamanho de um campo

Para alterar o tamanho de um campo CHAR ou VARCHAR no FireBird (ou InterBase 6.0 ou superior) basta executar o comando SQL abaixo:

ALTER TABLE NomeDaTabela ALTER NomeDoCampo TYPE NovoTipo;



Obs: Este comando não funciona se a alteração de tamanho implicar em perda de dados, ou seja, não serve para reduzir o tamanho de um campo.


11 comentários »

  1. Touche. Sound arguments. Keep up the amazing work.

  2. Augusto said

    obrigado pela dica, me ajudou muito, não estava conseguindo acertar a sintaxe.

  3. fried rice said

    Thank you for another magnificent post. The place else could anyone get
    that kind of info in such an ideal method of writing? I’ve a presentation subsequent week, and I
    am on the search for such info.

  4. Having read this I thought it was really informative. I appreciate you finding the time and energy to put this informative article together. I once again find myself spending way too much time both reading and posting comments. But so what, it was still worthwhile!

  5. this is trus that lrre less thaness than a week. I’ll let you all know when the next list i hen the next list i This is the currer list in less than a week. I’ll let you all know when the next list i This is the current list that I have. I should add anothe

  6. Hmm it appears like your site ate my first comment (it was super long) so I guess I’ll just sum it up what I wrote and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog blogger but I’m still new to everything. Do you have any suggestions for newbie blog writers? I’d genuinely appreciate it.

  7. tel rose said

    différents de cette qualité Céline tel rose Viens nous rejoindre avec tes chiennes, que tous puissent te féliciter. Le battement de mon cœur s’accélère alors que les

  8. Mafroui said

    Prenez du temps pour le shop web d’accesoires pour hommes et femmes. Allez jeter un coup d’oeil ! Ceux qui désirent des infos, prenez contact avec le service client

  9. Thanks, will subscribe to news 🙂 !

  10. Celebrity said

    Hi there! I am so grateful that I found your website. I really admire the dedication you put into offering the detailed information for free. I will definitely come back to your site for more. Keep up the good work.

  11. Gaming personal computers are not as challenging as you may perhaps assume, and doing your own gaming personal pc isn’t as challenging as a lot of persons would make you consider. Seeing that you previously have a distinct software in thoughts when building your very own gaming device, there are actually only three principal parts you have to have to feel concerned about, and every little thing else is truly secondary: the processor, movie card, and RAM.

RSS feed for comments on this post · TrackBack URI

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da

Está a comentar usando a sua conta Terminar Sessão /  Alterar )

Google photo

Está a comentar usando a sua conta Google Terminar Sessão /  Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão /  Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão /  Alterar )

Connecting to %s

%d bloggers like this: