Results 1 to 3 of 3

Thread: Alter

  1. #1
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253

    Unanswered: Alter

    I've been through the documentation, the online forums, and other sources...could someone please tell me what is wrong with this syntax?

    alter table amrobi2.holidays alter column holiday_desc VARCHAR(124);

    Thanks!
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Alter

    Originally posted by ansonee
    I've been through the documentation, the online forums, and other sources...could someone please tell me what is wrong with this syntax?

    alter table amrobi2.holidays alter column holiday_desc VARCHAR(124);

    Thanks!
    You might have used wrong documentation...

    alter table amrobi2.holidays alter column holiday_desc set data type VARCHAR(124)

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Alter

    what is your original column name/type/length ?


    You can only extend VARCHARs

    Read SQL Reference for your platform and version
    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •