Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Aug 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete Relationship USING CODE (Access 97 SR-2)

    Is it possible to detemine if a relationship exists between two tables and the, if one does, delete the relationship between two tables USING CODE?

    Thanks

  2. #2
    dave_hill
    Guest

    Re: Delete Relationship USING CODE (Access 97 SR-2)

    Check MS Knowledge Base article Q116145 - Create and Drop Tables and Relationships Using SQL DDL

    Also, check out the downloadable Access Knowledge Base help files on the site. Chock full of goodies!

  3. #3
    New Lounger
    Join Date
    Aug 2001
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete Relationship USING CODE (Access 97 SR-2)

    Thanks...I found the information. However, I am a bit new to this...So a bit more guidance is need. Specifically, the information tells me to use DDL to Drop the relationship, ie:

    ALTER TABLE Table2 DROP CONSTRAINT Relation1

    However I am uncertain what to put in place of Relation1

    Thanks

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete Relationship USING CODE (Access 97 SR-2)

    Check out <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=44019&page=& view=&sb=&o=&vc=1#Post44019>this post</A>

    Hopefully this will get you into the right ballpark...

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •