Viewing 3 posts - 1 through 3 (of 3 total)
This will generate a script to drop all FK's:
SELECT 'ALTER TABLE ' +
QUOTENAME( c.TABLE_NAME ) +
'...
October 10, 2003 at 5:14 pm
#477931
Try this explanation:
http://dbforums.com/arch/66/2003/5/790826
You don't need a parachute to skydive.
You only need a parachute to skydive twice.
October 10, 2003 at 5:09 pm
#477929
The problem is really with order of precedence. Forcing the order in which the clauses are evaluated should make the query work the way you think it should, e.g.:
WHERE...
October 10, 2003 at 4:59 pm
#477927