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)

2007-09-19 (first published: )

4,011 reads

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)

2006-10-24 (first published: )

3,092 reads

Blogs

Life Support 2008 – Audit Logons

By

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

By

This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs

Forums

SQL Query Assistance Required

By troy1w1w

Hi. I am wanting to know if there is a way to make this...

Stairway to Database Containers Level 3: Building Custom Container Images by Hand

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Stairway to Database Containers Level...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers