From: Adam M. <ada...@ou...> - 2006-11-23 13:01:29
|
I use MSSQLServer 8 and even though the constraints are accepted, I think I'm correct in saying you cant actually do a cascade delete! MySQL has changed since last looked, which is great news. adam | -----Original Message----- | From: bod...@li... | [mailto:bod...@li...] On Behalf Of | Peter Crowther | Sent: 23 November 2006 12:54 | To: Bodington developers | Subject: Re: [Bodington-developers] Deleting users | | > From: Adam Marshall | > ON DELETE CASCADE doesn't work with MySQL and MS SQLServer, | > what would you do about those DB's? | | Get a supported MSSQL version - it's supported on SQL Server 2000 and | newer using the same syntax Antony describes. SQL Server 7 is at the | end of its life, and sites running it should be thinking about | upgrading. | | - Peter | | ------------------------------------------------------------------------- | Take Surveys. Earn Cash. Influence the Future of IT | Join SourceForge.net's Techsay panel and you'll get the chance to share | your | opinions on IT & business topics through brief surveys - and earn cash | http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV | _______________________________________________ | Bodington-developers mailing list | Bod...@li... | https://lists.sourceforge.net/lists/listinfo/bodington-developers |