Question about adding a column to a key

[gbraden]

I have a table with 5 columns, and three of the columns comprise a unique key. I need to add a fourth column to that key, but I can't drop the table data.

I cannot use Enterprise Manager in this environment, so I am using an ASP page with a SQL window to run my commands.

Is there an easier way than saving the table data to a temp, dropping the table, recreating the table with the 4th column and moving the data back in?




Glen Braden

 

[gbraden]

I figured it out.

I identified the index, using a script I found on this forum (Aug 06).

Then I did an alter table drop index. with another alter table specifying the constraint and fields.

Am I allowed to give myself a star?


Glen Braden

 

[macleod1021]

You can try...I don't think it works tho