Generate Add Foreign Keys statements for the table

I was going through the painfull optimization of the database of creating better clustered indexes (not the default ones on the primary key).This operation was requiring removing all foreign keys to this table and then recreation them again.I created this script to optimize this quite tidious task.

1 (1)

2006-06-08 (first published: )

737 reads

Blogs

Daily Coping 24 Sept 2021

By

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

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Starting a career in cloud computing

By WojinRina

Hello, As the title says, might you have any advice to starting a career...

AWS S3 Questions

By lucasPeni

Hi all, Just starting out with AWS and had a few questions.. What are...

Volunteer For Something

By Grant Fritchey

Comments posted to this topic are about the item Volunteer For Something

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers