use db361K --SELECT index_id -- ,is_primary_key -- ,is_unique -- ,[name] select * FROM sys.indexes WHERE object_id = OBJECT_ID('TCode') order by index_id, [name]