Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Truncate Rss

Search for any content tagged truncate

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 2 of 2   
 

Truncate tables with foreign keys

Truncating tables with constraints always had been a pain, since we have to drop and recreate all the FKs. I created a script that takes care of dropping and recreating the foreign keys while truncating. Please use with caution! and always respect your Data !  Read more...
By Roshan Joe Joseph 2016/12/01 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 497 reads

Truncate or switch range of a partitioned table

Script to duplicate structure, switch or truncate choosen partitions of a table  Read more...
By Federico Iori 2013/06/03 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 1,421 reads
   Items 1 to 2 of 2