vsamantha35
SSChampion
Points: 11529
More actions
December 10, 2017 at 9:22 am
#402739
Hi All,
Looking for a TSQL script which can delete/truncate data from child tables first and then parent tables. Does anyone has an handy script to do DELETE's ??
Thanks,
Sam
Grant Fritchey
SSC Guru
Points: 398694
December 11, 2017 at 6:28 am
#1971526
Generally you just write the delete script for the children and then for the parent. there's no magic here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"- Theodore Roosevelt
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply