Technical Article

Clean up default constraints

The script scrapes out all default constraints (optional for particular column, table or script generation for the whole db) in SQL Server 2005 manner. Based on: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00a11.asp

2007-09-03 (first published: )

573 reads

Blogs

Daily Coping 28 Jun 2022

By

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

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

Returning To An Employer

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Returning To An Employer

SQL Server Collation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Collation

Replace calendar table multiplier column with date logic

By Chrissy321

Hello All, It's been a while. See the DDL/DML. I have a multiplier field...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers