Foreign Key DDL wizard

This script can be run when you want to do batch processing on a database, such as a dynamic truncate statement for all tables in your database.  This script will actually script all the Foreign Keys in your database, and then store them into a table called FOREIGN_KEY_TEMP.  It will then generate, and execute, all […]

2004-01-22

208 reads

Generate all database foreign keys

This script will create another script that has all foreign key DDL that exists in a given database.   You only have to run this, and then select the results of this script and paste it into another query window, or if for some reason you have lost your DDL this will enable you to retrieve […]

2003-11-12

221 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

Transcation Log Backup Restoration Time

By Harshana-455711

Hi Is anyone know please advice, how much time will take for restoration 250GB...

Slimymed

By ouhgqabhugop

https takeapills com/slimymed-de/  

Update 22/01/2020 - ICQ678924920 => Sell Credit Card/DeadFullz/Gifts Card

By jack678924920

Hi guys! Call me Jack.. Update 22/01/2020 12:04 PM LIST CREDIT CARD AND GIFT...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers