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

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

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

You don’t need a blockchain

By

After writing several posts about a neat feature in Azure SQL called system-versioned ledger...

Daily Coping 27 Oct 2021

By

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

Read the latest Blogs

Forums

Error connecting using AlwaysON Listener

By Arsh

Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...

C?p nh?p d? li?u dánh giá sàn icmarkets chu?n xác nh?t

By sanicmarkets

Ic markets là sàn th? nào dây ? gi?y phép và các th? t?c...

Mumbai to Lakshadweep cruise

By omane

- Explore beautiful cruise destinations like Goa, Lakshadweep, Colombo, Maldives & many more by...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers