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

212 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

222 reads

Blogs

Updating my Kubernetes Raspberry Pi Cluster to containerd

By

There’s been a lot of conversations happening on twitter over the last couple of...

Daily Coping 3 Dec 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

Read the latest Blogs

Forums

Report based on dynamic columns

By ca4fil

Hi all, Can anyone help please? I am trying to do the below report,...

There are no SQL Server instances or shared features that can be updated -2017

By EasyBoy

Hi Please Assist. I am trying to install SQL SERVER CU 22 on SQL...

How can I exclude records from this table?

By NineIron

How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers