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,012 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,094 reads

Blogs

T-SQL Tuesday #125 – Unit testing databases – we need to do this!!

By

Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...

T-SQL Tuesday Live–7 Apr 2020

By

Last week went a little crazy, and I learned something: don’t post a Zoom...

Getting Your dbatools Version–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Dial sbcglobal helpline for Customer Service

By vancevanse0

SBCGlobal Email Settings: If you are going to use Sbcglobal for your email applications...

How not to have sql to restart on the same node but failover on 1st failure in a

By SQLRocker

Hi, By default sql tries to restart on the same node in case of...

Do I need to update statistics after compressing table?

By VoldemarG

I page-compressed a table with one Clustered and 4 non-clustered indexes, 5 million rows....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers