Professional Web Applications Themes

Foreign Key help - Microsoft SQL / MS SQL Server

I am tring to creat a Foreign key relationship after a table has already been created. I want the option for "enforcing relationships for tion" and for "enforce relationships for inserts and deletes turned off. Here is my code presently. THanks. ALTER TABLE [dbo].[permits] WITH NOCHECK ADD CONSTRAINT vPermitMainStem_FK Foreign KEY (Main_Stem) References vPermitMainStem(Main_Stem) Ben...

  1. #1

    Default Foreign Key help

    I am tring to creat a Foreign key relationship after a
    table has already been created. I want the option
    for "enforcing relationships for tion" and
    for "enforce relationships for inserts and deletes turned
    off.

    Here is my code presently. THanks.

    ALTER TABLE [dbo].[permits] WITH NOCHECK ADD
    CONSTRAINT vPermitMainStem_FK Foreign KEY
    (Main_Stem) References vPermitMainStem(Main_Stem)

    Ben
    Ben Guest

  2. #2

    Default Re: Foreign Key help

    "enforce relationships for inserts and deletes" is an Access option, is it?
    There is no such thing in SQL Server, foreign keys are always on. WITH
    NOCHECK only doesn't check the Foreign key when it is created, but
    afterwards it is always applied. It is not a recommended option, because
    later rows that violate the foreign key might cause problems.

    If you want "enforcing relationships for tion" off, you can specify
    NOT FOR TION.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Ben" <nu> wrote in message
    news:0ca901c35129$30d4b060$gbl... 


    Jacco Guest

  3. #3

    Default Re: Foreign Key help

    Hi Ben,

    I saw what you mean now, sorry. It's been ages since I have designed a table
    in EM, I do everything in Query yzer because there are a number of
    things you can't do in EM, creating named Primary keys and defaults for
    example.

    Checking the "enforce relationships for inserts and deletes" box disables
    the foreign key constraint; the constraint is still created normally, but
    directly disabled with ALTER TABLE. If you want to see the exact SQL you can
    make your changes and then click on the "Save change script" button (3rd
    from the left) and study the script that is produced.

    hth

    Jacco

    "Ben" <nu> wrote in message
    news:007901c35138$090e81f0$gbl... 
    > Access option, is it? 
    > always on. WITH 
    > created, but 
    > option, because 
    > problems. 
    > off, you can specify [/ref]
    > turned 
    > >
    > >
    > >.
    > >[/ref][/ref]


    Jacco Guest

Similar Threads

  1. Foreign key
    By Bruno Guerpillon in forum MySQL
    Replies: 6
    Last Post: November 24th, 07:29 AM
  2. foreign keys
    By Sybrand Bakker in forum Microsoft Access
    Replies: 2
    Last Post: July 25th, 10:04 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139