Re: [Bodington-developers] Deleting users

[Peter C. <Pet...@me...>]

> From: Adam Marshall
> I use MSSQLServer 8 and even though the constraints are=20
> accepted, I think
> I'm correct in saying you cant actually do a cascade delete!=20

create table pri(p int not null primary key)
create table furrin(f int not null references pri(p) on delete cascade)
insert into pri values(1)
insert into furrin values(1)
delete from pri where p=3D1
select * from furrin
drop table furrin
drop table pri

The select * returns 0 rows, as expected if this works.  Tested on SQL
Server 2000 SP4, SQL Server 2005 SP1.

		- Peter