creating unique constraint

S

Sajid

Hello

Can any one tell me how to create a unique constraint on
multiple fields WITHOUT setting them as primary key.

Regards
Sajid
 
S

Sam

In table design view, choose view-indexes. Create an index using all the
required fields, set this index to be unique but not the primary key.

HTH
Sam
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Contraints, primary keys 2
Creating non-PK unique constraints in Access 2003 1
CONSTRAINT [pk_SwitchboardItems] 1
Overriding constraint violation message 8
How to implement two shifts per day with multiple teams 0
Unique Foreign Key constraint?!?! 5
Primary key question 4

Top