Delete Data

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.

5 (3)

You rated this post out of 5. Change rating

2019-12-10

2,585 reads

Blogs

Adding a Local Model to Ollama through the GUI

By

I saw some good reviews of the small gemma3 model in a few places...

Connect resiliently to SQL Server

By

 Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...

T-SQL Tuesday #191: Invitation–Your Favorite String Parsing

By

It’s that time of the month, and I’m late. My apologies. I had a...

Read the latest Blogs

Forums

Bat and SQL script to generate DB user permissions for all Databases in SQL server

By Srinivas Merugu

Comments posted to this topic are about the item Bat and SQL script to...

PWDCompare

By Steve Jones - SSC Editor

Comments posted to this topic are about the item PWDCompare

The Improvement Limit

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Improvement Limit

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers