Showing posts with label enables. Show all posts
Showing posts with label enables. Show all posts

Wednesday, March 21, 2012

force sql to ignore dependancies

Is there any way to force sql to allow a table delete even if it has
dependancies? I just need to drop and recreate the table with ansi_nulls
enables so the table be absent briefly.
Thanks,
Jim"Jims" <biz@.neocasa.net> wrote in message
news:eqd3EckiGHA.3496@.TK2MSFTNGP04.phx.gbl...
> Is there any way to force sql to allow a table delete even if it has
> dependancies? I just need to drop and recreate the table with ansi_nulls
> enables so the table be absent briefly.
See my reply to your next post. This approach makes no sense.sql