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: )

734 reads

Blogs

Why I am running for the PASS Board in 2020

By

This blog post lists the reasons why I felt the need to run for...

Blog Refresh – Growing Readers

By

Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...

Daily Coping 27 Oct 2020

By

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

Read the latest Blogs

Forums

SSIS 2017 stopped running, not status is Pending Execution

By ConnieD

We have 3 sql agent jobs that are running SSIS packages.  Until this past...

cannot find MSOLEDBSQL driver for SSIS 2019 connection manager

By sqlfriend

In the list of connection manager driver, I cannot  find MSOLEDBSQL, There is a...

Lean Coffee

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Lean Coffee

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers