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,095 reads

Blogs

[Video] Azure SQL Database – Import a Database

By

Quick Video showing you have to use a BACPAC to “import” a database into...

Requesting Comments on the SQLOrlando Operations Manual

By

For the past couple weeks I’ve been trying to capture a lot of ideas...

Ignoring Comments in SQL Compare

By

Recently I had a client that wanted to know how they could use SQL...

Read the latest Blogs

Forums

Installing SQL server with DBAtools

By alex.palmer

Hi I'm looking to automate installing SQL 2017 as part of an automated server...

Rules in PostgreSQL

By sabyda

Comments posted to this topic are about the item Rules in PostgreSQL

Ordering with NULL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Ordering with NULL

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers