Re: nullify delete rule?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 18:12:23 +0530

ON DELETE CASCADE will delete the child tables also. It willnot nullify the
values as in the problem definition. 

-- 
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Uri Dimant" <urid@iscar.co.il> wrote in message
news:ercdcUmPEHA.2876@TK2MSFTNGP09.phx.gbl...
> Martin
> Have a look into ON DELETE CASCADE  in the BOL?
>
> "Martin Hellat" <anonymous@discussions.microsoft.com> wrote in message
> news:8C873A8D-410F-4F38-8D9C-753BBA44A1A6@microsoft.com...
> > Hey,
> >
> > Is there a nullify delete rule implemented in sql server 2000? ( i.e. if
i
> delete a record in master table then all parent keys in detail tables are
> set to NULL ).
> >
> > Thank You in advance,
> >   Martin.
>
>

Relevant Pages

  • Re: How to find first not null value in column
    ... Martin R writes: ... > How to find first not null value in column whitout chacking whole table ... SQL Server is likely to seek that index, and you would get the lowest ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: New to SQL server
    ... SQL SERVER WORKS LIKE A CHARM, PLEASE EXPLAIN YOUR SO CALLED BUGS ... Both Cascade referential actions in DRI and table-level CHECK ... self-referencing FKs and inline constraints. ... you could write a trigger to perform the cascade action for ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Pb with on delete cascade... HELP!!!
    ... Cascading foreign keys for update and delete were introduced in SQL Server ... > I really don't understand what is wrong with my database... ... use this "DELETE ON CASCADE" command:o( ...
    (microsoft.public.sqlserver.programming)
  • Re: New to SQL server
    ... and cascading updates and deletes. ... I think DRI is better implemented in Jet 4.0 than SQL Server. ... ON UPDATE CASCADE); ...
    (microsoft.public.access.adp.sqlserver)