Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2014

    Unanswered: sybase index type change


    I wanted to change the data type of an index column, how can this be done ? I believe we have to drop the index and then change the data type and then create the index. However, i cannot find the index name for a particular column to drop it. How can this be done ?

    thankful to your suggestions

  2. #2
    Join Date
    Feb 2012
    have you tried this command

    sp_helpindex <tablename> --this will list all indexes for particular columns

Posting Permissions

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