I think your approach is not good. Even if you manage to resolve it now, you'll have issues later if going this way.

My suggestion is to re-create your table a bit differently:

CREATE TABLE [dbo].[MYTABLE]

(

[ID] int identity(1,1) primary key,

[TND_CD] [smallint] NOT NULL,

[ACCPT_FOR_SLS_FG] /*???*/

[STR_ID] [int] NOT NULL,

[HIER_ID] [int] NOT NULL,

[LOC_ID] [int] NOT NULL

)

Do not create CONSTRAINT [PK_MYTABLE] PRIMARY KEY CLUSTERED

you already have primary clustered key (surrogate). You can create non-clustered key instead of the old clustered key.

Then keep on with your exhibitions.

Regards,

Igor