Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: Modifying field which has an index

    If I modify a field to increase it's length

    Code:
    ALTER TABLE   vslsitet   modify   natl_brd_no   char(30)   NULL
    Will I need to drop and recreate it's index? Currently, it's a char(8) field.

    Sybase Adaptive Server 12.5
    -Chuck

  2. #2
    Join Date
    Dec 2005
    Posts
    39
    No, you need not. But it would do no harm to drop & recreate..

Posting Permissions

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