by Dietrich L. Westbrook » Tue, 28 Aug 2001 07:08:13
i am getting an error when i try to use the ON DELETE action when adding a
foriegn key constraint.
Syntax:
ALTER TABLE [table1] ADD CONSTRAINT [FK_FKYCASCADEDELETE]
FOREIGN KEY ([column1]) REFERENCES [table2] (column1)
ON DELETE CASCADE
Error:
Server: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'ON'.
if i take out the 'ON DELETE CASCADE' it works fine. Need help?
Thanks!
Dietrich
by Ivan Arjentinsk » Tue, 28 Aug 2001 07:12:26
What version of SQL Server are you using?
--
Ivan Arjentinski
----------------------------------------------------------------------
You can deploy structural changes over production databases with the
SQL Schema Upgrade Wizard - www.aloeco.com/upgrader
----------------------------------------------------------------------
> i am getting an error when i try to use the ON DELETE action when adding a
> foriegn key constraint.
> Syntax:
> ALTER TABLE [table1] ADD CONSTRAINT [FK_FKYCASCADEDELETE]
> FOREIGN KEY ([column1]) REFERENCES [table2] (column1)
> ON DELETE CASCADE
> Error:
> Server: Msg 156, Level 15, State 1, Line 3
> Incorrect syntax near the keyword 'ON'.
> if i take out the 'ON DELETE CASCADE' it works fine. Need help?
> Thanks!
> Dietrich
by Dietrich L. Westbrook » Tue, 28 Aug 2001 08:00:18
> What version of SQL Server are you using?
> --
> Ivan Arjentinski
> ----------------------------------------------------------------------
> You can deploy structural changes over production databases with the
> SQL Schema Upgrade Wizard - www.aloeco.com/upgrader
> ----------------------------------------------------------------------
> > Hello,
> > i am getting an error when i try to use the ON DELETE action when adding
a
> > foriegn key constraint.
> > Syntax:
> > ALTER TABLE [table1] ADD CONSTRAINT [FK_FKYCASCADEDELETE]
> > FOREIGN KEY ([column1]) REFERENCES [table2] (column1)
> > ON DELETE CASCADE
> > Error:
> > Server: Msg 156, Level 15, State 1, Line 3
> > Incorrect syntax near the keyword 'ON'.
> > if i take out the 'ON DELETE CASCADE' it works fine. Need help?
> > Thanks!
> > Dietrich
by Umachandar Jayachandra » Tue, 28 Aug 2001 11:22:42
--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )
1. Using sql to add/drop foreign keys constraints w/parent and child
Have this script that will add/drop foreign key
constraints with child relationships but I want to modify
so that I can also add/drop the FK relationship with the
parent.
Any ideas?
Thanks,
CTW
2. Bug in FP 9 for DB2 UDB EEE V6.1 for AIX ??
3. Adding a foreign key constraint
4. ADO ConnectionString to Sybase12
5. Adding Foreign Key constraint in SQL
7. Adding Foreign key constraints with the NOCHECK Option
8. SQL Server 7.0 Paper Licensing Requirement
9. Adding A Foreign Key constraint
10. Adding Foreign Key constraints outside of table def.
11. Integrity violation when adding foreign key constraint
12. Recursive SQL to drop and add Foreign Key constraints
13. Disabling foreign key constraint for delete only