Unique Fields

[kim1]

Hi Guys,

I want to do this

TableA (ColA, ColB, ColC, ColD)

Primary key: ColA, ColB

I want (ColC + ColD) a unique value

Do I have to create an index on ColC+ColD as Unique value in order to have a unique value for those 2 fields which are not part of the primary key?

Thank you very much for your help.
Kim

 

[RickCole]

If you put a Unique Constraint on a table SQL Server will automatically creates a UNIQUE index to enforce the uniqueness requirement.

On my tables I always put on Unique Constraints as indexes and make that index unique. My naming conventions tell me how my different indexes operate.

Rick.

 

[kim1]

Thanks a log Rick Kim