Viewing 3 posts - 1 through 4 (of 4 total)
This will generate a script to drop all FK's:
SELECT 'ALTER TABLE ' +
QUOTENAME( c.TABLE_NAME ) +
'...
You don't need a parachute to skydive.
You only need a parachute to skydive twice.
October 10, 2003 at 5:14 pm
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.
You don't need a parachute to skydive.
You only need a parachute to skydive twice.
October 10, 2003 at 5:09 pm
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...
You don't need a parachute to skydive.
You only need a parachute to skydive twice.
October 10, 2003 at 4:59 pm
Viewing 3 posts - 1 through 4 (of 4 total)