I was wondering if anyone had anything in their bag of tricks that
would detect any foreign key contraints on a table and break them. I
am constantly dropping/adding tables as part of a MSSQL 2000 utlity
function and I keep hitting an error if I drop a parent table that has
FKs.
Thanks.See if this helps you get on the right track:
http://sqljunkies.com/WebLog/amacha...onstraints.aspx
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"xenophon" <xenophon@.online.nospam> wrote in message
news:ulrn51pb732k09237hfk9u8iri2h7vl9pq@.
4ax.com...
> I was wondering if anyone had anything in their bag of tricks that
> would detect any foreign key contraints on a table and break them. I
> am constantly dropping/adding tables as part of a MSSQL 2000 utlity
> function and I keep hitting an error if I drop a parent table that has
> FKs.
> Thanks.
>
Sunday, March 11, 2012
Dynamically Drop FK Restraints?
Labels:
bag,
break,
constantly,
contraints,
database,
detect,
drop,
dynamically,
foreign,
iam,
key,
microsoft,
mysql,
oracle,
restraints,
server,
sql,
table,
thatwould,
tricks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment