SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by arekk / Drop table indexes, constraints and statistics / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 22:40:12 GMT20RE: Drop table indexes, constraints and statisticshttp://www.sqlservercentral.com/Forums/Topic404438-721-1.aspxHi arekk,I am receiving the following error msg by running the sp 'utl_drop_all_indexes' against a table which has a foreign key constraint in SQLSERVER 2000Error Msg:The constraint '<Constraint name>' is being referenced by table '<tbl name>', foreign key constraint '<FK name>'.Thanks,BaskarMon, 29 Jun 2009 04:08:37 GMTbaskar.t-1114393Drop table indexes, constraints and statisticshttp://www.sqlservercentral.com/Forums/Topic404438-721-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/30213/">Drop table indexes, constraints and statistics</A>[/B]Sat, 29 Sep 2007 11:17:40 GMTarekk