Technical Article

Delete constraints - SQL Server 2005

This script will DELETE ALL constraints within the database that you define and in the following order: Foreign Key, Primary Key and then Unique Key.CAUTION:This script does not print out the ALTER TABLE statements, it drop the constraints immediately, therefore backup your database before testing or using this script. I ran the script below and […]

5 (3)

You rated this post out of 5. Change rating

2007-09-19 (first published: )

4,077 reads

Technical Article

Data Dictionary - SQL 2005

I know there are several scripts out there showing you on how to create a data dictionary... I created this script for creating a data dictionary for SQL 2005. It stores the data into a table in the database that you choose. The script only stores the table name, column name, default value of the […]

5 (1)

You rated this post out of 5. Change rating

2006-10-24 (first published: )

3,119 reads

Blogs

Updating SSMS is Easy (w/ v21)

By

I’ve been using the SSMS preview for v21. This is the next evolution of...

Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025

By

I’m excited to announce that on June 17 – 18, 2025, I’ll be running...

How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database

By

I have recently had the privilege of working with multiple clients who have been...

Read the latest Blogs

Forums

Third party backup softwares

By ashrukpm

Hi Team, Can you someone suggest a few good third part backup tools, with...

2022 SSIS PackageFormatVersion?

By TG

Recently I upgraded my ssis package from 2016 to 2022, but package format version...

Meta AI by Facebook: A New Contender in the AI Battle

By Daniel Calbimonte

Comments posted to this topic are about the item Meta AI by Facebook: A...

Visit the forum

Question of the Day

The Monitor Server

What does the monitor server do in log shipping?

See possible answers