Data cleanup

Technical Article

T-SQL script to purge all the tables including foreign key references

  • Script

T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2019-12-10

2,686 reads

Blogs

A Pursuit of Lifelong Learning

By

The following came across my YouTube feed today. It’s an interview with General James...

Advice I Like: Time and Focus

By

“You don’t need more time because you already have all the time that you...

Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals

By

I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...

Read the latest Blogs

Forums

Anyone have a SQL Server 2014 Developer Edition DVD?

By Mike Scalise

Hi all, I’m looking for a SQL Server 2014 Developer Edition DVD. Does anyone...

How have you encouraged communication at work?

By Rod at work

I do have a question. At work, some groups of people have an inordinate...

What Did Healthy Look Like?

By Laura Copeland

Comments posted to this topic are about the item What Did Healthy Look Like?

Visit the forum

Question of the Day

DML Trigger Types

How many types of DML triggers are there?

See possible answers