sp_truncate

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sergey Benner » sp_truncate

sp_truncate

Rate Topic

Display Mode

Topic Options

Author

Message

sergey.benner

Posted Friday, January 16, 2009 7:27 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 6:28 PM
Points: 210, Visits: 158

Comments posted to this topic are about the item sp_truncate

Post #638051

Jason Miller-476791

Posted Friday, January 23, 2009 5:04 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 18, 2010 5:25 AM
Points: 162, Visits: 694

Like the script. However, I noticed 2 areas for improvement. If I'm "deleting" all the rows from the primary key, I want all the foreign rows wiped out as well. Also, the foreign key constraints get dropped and recreated, but it is missing the cascade options.

I have a similar procedure, but mine was written for a specific table. I guess I could modify it to handle more, but it would probably be easier to modify your procedure.

Thanks, IMHO, that's a very valuable script.

Honor Super Omnia-
Jason Miller

Post #642375

Martin Goebbels

Posted Saturday, January 24, 2009 12:28 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 16, 2010 7:51 AM
Points: 6, Visits: 21

That is the kind of procedure all developer must have. Sure, there can be improvements, and you will make this code ever better.

Post #643029

sergey.benner

Posted Saturday, January 24, 2009 12:43 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 6:28 PM
Points: 210, Visits: 158

Thanks guys. Although it has a low rating here :D it really did save lots of time for me.
We had a bunch of tables which needed this kind of intervention so I had to make it.
thanks :)

Post #643037

kodracon

Posted Sunday, August 30, 2009 12:13 AM

Valued Member

Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55, Visits: 155

Hi All

this is my script that also attempts to truncate a referenced table:
http://www.sqlservercentral.com/scripts/Foreign+Key/65452/

Enjoy

Post #779537

sergey.benner

Posted Monday, August 31, 2009 2:08 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 6:28 PM
Points: 210, Visits: 158

I didn't use embedded sp_fkeys procedure there.
I did everything using the pure joins. :)
Heck... I wrote it - one year ago. lol

Post #779736

« Prev Topic | Next Topic »

Permissions