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)

2007-09-19 (first published: )

4,014 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)

2006-10-24 (first published: )

3,098 reads

Blogs

About blogging

By

A friend wants to get started and write a blog, and so asked me...

Daily Coping 26 Nov 2021

By

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

Daily Coping 25 Nov 2021

By

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

Read the latest Blogs

Forums

efficient large table cleanup

By Bruin

looking for examples on doing a large table cleanup where my attribute value selected...

ODBC - Pipeline component has returned HRESULT error code 0xC0208457

By yrstruly

I am trying to connect to MYSQL as a target/destination via ODBC. I am...

Trouble connecting MYSQL in SSIS

By yrstruly

I connect to MYSQL in SSIS with MYSQL data provider. I am getting the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers