Technical Article

Drop and Add Foreign Keys

Have you tried using DTS to load a database and those pesky foreign keys mess you up? This is actually two scripts, one to generate the SQL needed to drop all the Foreign Keys in a database and another to Add the Foreign Keys back when you are done. I've thrown in Disabling and Enabling […]

5 (9)

You rated this post out of 5. Change rating

2005-07-13 (first published: )

3,037 reads

Blogs

T-SQL Tuesday #182: Personal Integrity

By

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

SQL Saturday Oregon & SW Washington 2024

By

Wow I am so late in posting these notes! But this conference was amazing,...

Challenges Enterprises Face When Adopting AI

By

The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

Sparse Column Storage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sparse Column Storage

The Managed Cloud Database Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Managed Cloud Database Options

Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases

By Mike McQuillan

Comments posted to this topic are about the item Stairway to Snowflake Level 6...

Visit the forum

Question of the Day

Sparse Column Storage

When does a column declared as SPARSE use no storage?

See possible answers