Last post Nov 03, 2009 12:35 AM by ranacseruet
Nov 02, 2009 11:56 PM|ranacseruet|LINK
I am trying to change a unique key contraints of a table in my access db via query, but couldn't. Can anyone help? TO add, i used the following query:
Alter Table tblTest ADD CONSTRAINT u1 Unique(ID,ArchID)
Also, if there any way to change/add remove unique key via design view or any option?
Nov 03, 2009 12:20 AM|linick|LINK
Go to design view.
Right click and select Check Constraints.
There you can change the existing unique keys.
Nov 03, 2009 12:26 AM|Nishitha u|LINK
alter table tablename drop constraint constraintname
Nov 03, 2009 12:35 AM|ranacseruet|LINK
the option was in 'indexes', not like 'check contraints', may yours & my access version are diference as I am using version 2007. Thanks