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

You rated this post out of 5. Change rating

2007-09-03 (first published: )

578 reads

Blogs

Master SQL Subqueries with This Free Course

By

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

Removing the REST Endpoint in the Data API Builder

By

The more I work with the Data API Builder (DAB), the more I lean...

T-SQL Tuesday #182: Personal Integrity

By

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

Read the latest Blogs

Forums

Sending SQL Query Result via an Email in ADF

By BrainDonor

New to Azure Data Factory, and as a starting point, we're trying to see...

AlwaysOn Standard o Enterprise edition

By ante75

Hi everyone, I need advice from the experts, this is the structure I created...

How create a Google bigquery connection manager in SSIS

By jaango123

Hi So I have created a system dsn to google bigquery data warehouse. However...

Visit the forum

Question of the Day

Sparse Column Storage

When does a column declared as SPARSE use no storage?

See possible answers