Home ›
ASP.NET Forums » Data Access » Access Databases and AccessDataSource Control » Want to change unique key contraints via query

Want to change unique key contraints via query

Last post 11-03-2009 12:35 AM by ranacseruet. 3 replies.

Sort Posts:

  • Want to change unique key contraints via query

    11-02-2009, 11:56 PM
    • Member
      2 point Member
    • ranacseruet
    • Member since 07-20-2008, 5:15 AM
    • Posts 10

    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?


    Regards



    My BLog

  • Re: Want to change unique key contraints via query

    11-03-2009, 12:20 AM
    Answer
    • Participant
      1,258 point Participant
    • linick
    • Member since 10-27-2009, 10:04 AM
    • Trivandrum
    • Posts 242

    Hi,


    Go to design view.

    Right click and select Check Constraints.

    There you can change the existing unique keys.

    Lini C K

    ========================================================================
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • Re: Want to change unique key contraints via query

    11-03-2009, 12:26 AM
    • Member
      434 point Member
    • Nishitha u
    • Member since 10-29-2009, 12:14 PM
    • Posts 82

    alter table tablename drop constraint constraintname

    Please remember to mark the replie(s) as answers if they help

    Nishitha U

  • Re: Want to change unique key contraints via query

    11-03-2009, 12:35 AM
    • Member
      2 point Member
    • ranacseruet
    • Member since 07-20-2008, 5:15 AM
    • Posts 10

    the option was in 'indexes', not like 'check contraints', may yours & my access version are diference as I am using version 2007. Thanks

    My BLog
Page 1 of 1 (4 items)
RSS Available

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.