MS SQL Delete all the data from the tables.
by brian on Nov.21, 2008, under coding, mmsql, sql
Here’s a helpful, and perhaps dangerous, little tidbit of code for SQL Server 2005. It deletes all of the data from all of the tables. To be completely effective, the command may need to be run more than once because of foreign keys. Basically run it until there aren’t any errors. Then the db is clean and empty of all data.
exec sp_MSForeachTable "delete from ?"
the sp_MSForeachTable is a very useful system stored procedure.
126 comments for this entry:
-
Welcome
Welcome to the feed Bee Eee blog. Hope you enjoy the tips and information that's interesting to me.
Sick of trying to qualify for that auto loan? Let the loan officers bid to give you a loan! It's free and could land you that loan that you really need! 
December 18th, 2010 on 6:07 am
████████►BUY CIALIS◀████████…
▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲…
December 22nd, 2010 on 8:18 pm
cephalexin dosage for dogs…
Buygeneric drugs…
December 24th, 2010 on 1:37 pm
Abilify…
Buygeneric pills…
December 27th, 2010 on 3:53 am
Abilify@official.site” rel=”nofollow”>……
Buyno prescription…
December 27th, 2010 on 2:03 pm
actonel@adverse.reactions” rel=”nofollow”>……
Buygeneric meds…
December 29th, 2010 on 4:19 pm
Allegra@official.site” rel=”nofollow”>……
Buygeneric pills…
December 30th, 2010 on 3:54 am
allopurinol@and.coumadin” rel=”nofollow”>……
Buygeneric drugs…
December 31st, 2010 on 3:37 am
ashwagandha@supplement.now” rel=”nofollow”>……
Buygeneric meds…
December 31st, 2010 on 10:30 am
atarax@and.hives” rel=”nofollow”>.…
Buygeneric drugs…
January 2nd, 2011 on 12:54 pm
Chantix@official.site” rel=”nofollow”>.…
Buydrugs without prescription…
January 4th, 2011 on 9:44 pm
Vitamin@B.now” rel=”nofollow”>.…
Buygeneric drugs…
January 10th, 2011 on 12:00 am
cephalexin@use.now” rel=”nofollow”>……
Buygeneric drugs…
January 21st, 2011 on 1:19 am
Depakote@official.site” rel=”nofollow”>……
Buyit now…
January 21st, 2011 on 2:48 am
depakote@400mg.now” rel=”nofollow”>.…
Buywithout prescription…
February 3rd, 2011 on 6:41 am
Benuryl…
Buywithout prescription…
February 3rd, 2011 on 10:55 am
Zyrtec…
Buygeneric drugs…
February 3rd, 2011 on 5:33 pm
side effects zyprexa overdose breathing autonomic…
Buyno prescription…
February 3rd, 2011 on 8:14 pm
Zyrtec…
Buygeneric pills…
February 4th, 2011 on 6:43 am
zovirax acyclovir…
Buydrugs without prescription…
February 6th, 2011 on 7:43 am
Zyrtec…
Buygeneric drugs…
February 6th, 2011 on 9:31 pm
xopenex coupon…
Buyno prescription…
February 6th, 2011 on 11:42 pm
zyprexa increase eps complaints…
Buyno prescription…
March 3rd, 2011 on 2:10 pm
yaz warnings…
Buynow…
March 3rd, 2011 on 2:34 pm
Vitamin B…
Buygeneric drugs…
March 3rd, 2011 on 3:52 pm
kids tylenol recall…
Buygeneric meds…
March 5th, 2011 on 9:38 pm
Rogaine…
Buyno prescription…
March 6th, 2011 on 3:49 am
should i stop savella before surgery…
Buygeneric meds…
March 7th, 2011 on 10:17 am
Rogaine…
Buydrugs without prescription…
March 8th, 2011 on 2:59 am
Seroquel…
Buywithout prescription…
March 8th, 2011 on 3:19 pm
Pulmicort…
Buywithout prescription…
March 9th, 2011 on 12:48 am
Synthroid…
Buywithout prescription…
March 9th, 2011 on 6:37 pm
Zyprexa…
Buyno prescription…
March 9th, 2011 on 11:39 pm
Purim…
Buyno prescription…
March 10th, 2011 on 1:23 pm
Risperdal…
Buydrugs without prescription…
March 11th, 2011 on 8:46 am
Reglan…
Buywithout prescription…
March 28th, 2011 on 7:41 am
Pyridium@Pyridium.Pyridium” rel=”nofollow”>……
Buygeneric meds…
March 29th, 2011 on 2:22 am
Prozac@Prozac.Prozac” rel=”nofollow”>……
Buynow…
March 29th, 2011 on 2:16 pm
Pulmicort@Pulmicort.Pulmicort” rel=”nofollow”>..…
Buyit now…
March 29th, 2011 on 8:45 pm
Prozac@Prozac.Prozac” rel=”nofollow”>……
Buygeneric drugs…
March 30th, 2011 on 6:00 am
Purim@Purim.Purim” rel=”nofollow”>..…
Buygeneric pills…
March 30th, 2011 on 10:48 am
Strattera@Strattera.Strattera” rel=”nofollow”>……
Buynow it…
March 30th, 2011 on 9:26 pm
Prozac@Prozac.Prozac” rel=”nofollow”>.…
Buywithout prescription…
March 31st, 2011 on 10:03 am
Cialis@Cialis.Cialis” rel=”nofollow”>..…
Buyno prescription…
March 31st, 2011 on 11:59 am
Rogaine@Rogaine.Rogaine” rel=”nofollow”>..…
Buynow it…
March 31st, 2011 on 4:56 pm
prozac@is.great” rel=”nofollow”>……
Buygeneric drugs…
April 1st, 2011 on 7:02 am
……
Buygeneric pills…
April 2nd, 2011 on 2:23 am
insulin@glargine.la” rel=”nofollow”>.…
Buygeneric pills…
April 2nd, 2011 on 7:35 am
can@you.take.aleve.and.darvocet.together” rel=”nofollow”>..…
Buygeneric drugs…
April 2nd, 2011 on 9:27 pm
how@to.get.quinine” rel=”nofollow”>.…
Buywithout prescription…
April 3rd, 2011 on 10:37 am
losee@weight.on.coumadin” rel=”nofollow”>..…
Buygeneric meds…
April 4th, 2011 on 11:55 am
prevacid@childrens.chewable” rel=”nofollow”>.…
Buygeneric drugs…
April 4th, 2011 on 11:34 pm
lidocaine@generic.name” rel=”nofollow”>……
Buygeneric pills…
April 5th, 2011 on 11:03 am
abilify@urges.results” rel=”nofollow”>..…
Buygeneric drugs…
April 5th, 2011 on 1:36 pm
……
Buygeneric drugs…
April 6th, 2011 on 8:47 am
fml@internet.lingo” rel=”nofollow”>..…
Buyit now…
April 6th, 2011 on 10:33 am
folic@acid.hpv” rel=”nofollow”>..…
Buyno prescription…
April 6th, 2011 on 8:33 pm
oral@gentamicin.supllements.and.horses” rel=”nofollow”>……
Buygeneric drugs…
April 6th, 2011 on 10:30 pm
somnolence@and.geodon” rel=”nofollow”>..…
Buywithout prescription…
April 6th, 2011 on 11:14 pm
wholesale@ginseng.root” rel=”nofollow”>……
Buyno prescription…
July 18th, 2011 on 9:03 am
buy@generic.LEVITRA” rel=”nofollow”>……
Need cheap generic LEVITRA?…
July 29th, 2011 on 1:46 pm
Cheap@Abilify.Online” rel=”nofollow”>..…
Buygeneric meds…
July 30th, 2011 on 12:32 pm
Purchase@Cheap.Acai” rel=”nofollow”>……
Buygeneric drugs…
July 31st, 2011 on 7:05 am
Purchase@Acai.Without.Prescription” rel=”nofollow”>..…
Buynow it…
July 31st, 2011 on 8:38 am
Buy@Acai.500mg” rel=”nofollow”>.…
Buynow it…
July 31st, 2011 on 10:17 am
Generic@Acai.500mg.Without.Prescription” rel=”nofollow”>..…
Buyno prescription…
July 31st, 2011 on 11:24 pm
Buy@Discount.Coral.Calcium” rel=”nofollow”>..…
Buygeneric meds…
August 1st, 2011 on 6:03 am
Purchase@Discount.Abana” rel=”nofollow”>..…
Buygeneric pills…
August 1st, 2011 on 12:36 pm
Buy@Generic.Abilify” rel=”nofollow”>……
Buywithout prescription…
August 1st, 2011 on 2:03 pm
Order@Abilify.Without.Prescription” rel=”nofollow”>..…
Buygeneric drugs…
August 2nd, 2011 on 1:53 am
Order@Cheap.Coral.Calcium” rel=”nofollow”>.…
Buygeneric drugs…
August 4th, 2011 on 5:27 pm
Purchase@Generic.Acai” rel=”nofollow”>..…
Buygeneric drugs…
August 5th, 2011 on 2:35 pm
Order@Cheap.Accupril” rel=”nofollow”>.…
Buygeneric drugs…
August 8th, 2011 on 10:28 am
Cheap@Aciphex.20mg” rel=”nofollow”>.…
Buygeneric meds…
August 9th, 2011 on 1:33 am
Buy@Cheap.Acomplia” rel=”nofollow”>.…
Buygeneric pills…
August 10th, 2011 on 7:13 pm
Actonel@35mg.Without.Prescription” rel=”nofollow”>.…
Buygeneric drugs zfk…
August 12th, 2011 on 12:18 pm
Order@Discount.Adalat” rel=”nofollow”>.…
Buygeneric meds unm…
August 13th, 2011 on 6:31 am
Order@Discount.Abilify” rel=”nofollow”>..…
Buygeneric pills zdg…
August 13th, 2011 on 8:39 am
Cheap@Abilify.Online” rel=”nofollow”>..…
Buygeneric drugs krg…
August 13th, 2011 on 9:11 am
Get@Abilify.Online” rel=”nofollow”>..…
Buynow it vhx…
August 13th, 2011 on 1:19 pm
Order@Abilify.Without.Prescription” rel=”nofollow”>..…
Buywithout prescription dyo…
August 14th, 2011 on 5:10 pm
Purchase@Acai.Without.Prescription” rel=”nofollow”>.…
Buyit now ojb…
August 15th, 2011 on 6:40 am
Buy@Cheap.Energy.Boost” rel=”nofollow”>……
Buygeneric meds svb…
August 17th, 2011 on 12:28 pm
Cheap@Generic.Accutane” rel=”nofollow”>..…
Buyno prescription gdt…
August 18th, 2011 on 8:38 pm
Cheap@Generic.Aciphex” rel=”nofollow”>..…
Buyno prescription lka…
August 19th, 2011 on 5:13 am
Generic@Aciphex.20mg.Without.Prescription” rel=”nofollow”>.…
Buygeneric drugs itj…
August 19th, 2011 on 11:09 am
Order@Acomplia.Online” rel=”nofollow”>.…
Buygeneric drugs axm…
August 19th, 2011 on 2:14 pm
Purchase@Acomplia.Online” rel=”nofollow”>..…
Buyno prescription jui…
August 26th, 2011 on 3:06 pm
buy@acai.berry.juice” rel=”nofollow”>..…
Buygeneric drugs…
August 26th, 2011 on 5:46 pm
accutane@krupnick.class.action” rel=”nofollow”>..…
Buynow…
August 27th, 2011 on 11:06 pm
abilify@company.buy” rel=”nofollow”>.…
Buywithout prescription…
August 28th, 2011 on 5:46 am
blue@sky.energy.solar.boost.3048” rel=”nofollow”>……
Buynow it…
August 29th, 2011 on 1:26 am
amoxicillin@online.buy” rel=”nofollow”>.…
Buygeneric drugs…
October 16th, 2011 on 7:19 pm
herpes kelly dating kansas…
Buy_no prescription…
October 18th, 2011 on 7:49 am
strong insulin…
Buy_generic meds…
October 19th, 2011 on 3:49 am
erectile dysfunction herbal treatment…
Buy_drugs without prescription…
October 19th, 2011 on 7:09 am
brown algae good for slow thyroid…
Buy_generic drugs…
October 19th, 2011 on 3:30 pm
novo 50 allergy medicine…
Buy_now it…
October 20th, 2011 on 10:50 pm
does testosterone make you gain weight…
Buy_generic drugs…
October 23rd, 2011 on 12:17 am
lithium alcohol…
Buy_generic drugs…
October 25th, 2011 on 3:02 pm
embed video webpage…
Buy_generic drugs…
October 26th, 2011 on 4:02 pm
what is plavix…
Buy_drugs without prescription…
October 26th, 2011 on 10:42 pm
postpartum remeron…
Buy_no prescription…
October 27th, 2011 on 5:02 pm
medication errors 2nd ed…
Buy_no prescription…
October 27th, 2011 on 10:02 pm
drugs and crime and treatment…
Buy_generic drugs…
October 29th, 2011 on 11:35 am
joke male birth control…
Buy_generic meds…
October 30th, 2011 on 2:59 pm
prozac daily strength…
Buy_generic pills…
October 30th, 2011 on 9:39 pm
acne in cats…
Buy_it now…
October 31st, 2011 on 8:59 pm
nursing times alzheimer mavis ford…
Buy_it now…
November 1st, 2011 on 8:39 am
diseaeses contracted from sand fleas…
Buy_now it…
November 1st, 2011 on 6:39 pm
pet ct scan results accuracy cancer…
Buy_drugs without prescription…
November 2nd, 2011 on 1:19 am
pictures of herpes blisters…
Buy_generic pills…
November 3rd, 2011 on 7:46 pm
reversing alcohol induced neuropathy…
Buy_generic meds…
November 4th, 2011 on 5:45 am
natural cures for premature ejaculation…
Buy_generic drugs…
November 5th, 2011 on 9:23 am
canadian paediatric diabetes association…
Buy_now…
November 6th, 2011 on 2:03 am
discovery of zinc in human health…
Buy_now…
November 6th, 2011 on 5:03 pm
emotions surviveing uterine cancer…
Buy_generic meds…
November 7th, 2011 on 6:02 pm
clinical studies of clonidine…
Buy_no prescription…
November 8th, 2011 on 1:16 pm
diet generator reviews…
Buy_it now…
November 8th, 2011 on 7:56 pm
psychiatric care model…
Buy_generic meds…
November 10th, 2011 on 5:17 am
maple syrup and lemon juice diet…
Buy_it now…
November 11th, 2011 on 1:17 am
most successful diet ever…
Buy_generic pills…
November 12th, 2011 on 2:17 am
sleep apnea side effect of lexapro…
Buy_generic pills…
November 13th, 2011 on 11:37 am
acute angle-closure glaucoma…
Buy_drugs without prescription…
November 13th, 2011 on 7:57 pm
regulations for dementia units…
Buy_drugs without prescription…
December 10th, 2011 on 2:29 am
can@you.give.risperdal.and.abililfy.together” rel=”nofollow”>..…
Buygeneric meds…
December 11th, 2011 on 1:56 am
benadryl dogs…
Buy_generic drugs…