MS SQL 2005 Studio, how to set foreign key with referential keys

[flyclassic22]

hi, i 've table with orderid a foreign key to the ORDERS table, however, i forgotten to set ON DELETE CASADE while assigning the foreign key that time. Now how do i re set it? Is there any way out with SQL 2005 Studio Express? Or what kinda of Query Command should i type? I dunno how to Alter Table foreign key constraints command.. Any one could help? THANKS in Advanced!

 

[jbenson001]

Try the SQL Server Programming forum:
forum183