I have some tables that are FKed and I turned on Delete cascade. I have two questions.
1) How come I can not see that rule? I see it in the table design but I can not see it in when I try to script the table. I need to promote this change from dev to stage..prod
2) Is there a way to turn on cascade delete through scripting? Another words we are going to use this method to delete data (no audit trail needed) eventually throughout the db. Is there a way to turn it on for all fk's. We are using 2005 so I would want the option of null, no action, and default.
I appreciate any information.