Home Forums SQL Server 2008 T-SQL (SS2K8) Weird behavior with a foreign key and "on delete set null" RE: Weird behavior with a foreign key and "on delete set null"

  • September 19, 2012 at 1:35 pm

    #1539773

    it looks like sp_help does nto correctly identify the delete actions.

    if i run this i see the action correctly:

    select * from sys.foreign_keys

    there's a connect item complaining about it here:

    http://connect.microsoft.com/SQLServer/feedback/details/616475/sp-help-doesnt-show-set-null-in-foreign-keys

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!