You can get index info using system stored procedure.
sp_helpindex studemo
>Hello group
>
>I am trying to update a table with fresh data. with the following syntax
>
>DELETE FROM studemo WHERE suniq in (SELECT suniq FROM cisstudemo)
>
>INSERT INTO studemo
>SELECT * FROM cisstudemo
>
>I get the following message.
>
>
>Server: Msg 2601, Level 14, State 3, Line 3
>Cannot insert duplicate key row in object 'studemo' with unique index 'studemU1'.
>The statement has been terminated.
>What can I do to find unique index studemU1 or work around this?
>Thanks
>Jim
>
>The table definitions
>
>are
>
< snip >
--sb--