Subversion
Written by: Lorna Jane Mitchell
Featured Refcardz: Top Refcardz:
  1. Git
  2. DNS
  3. Data Mining
  4. Spring Data
  5. Subversion
  1. Spring Data
  2. Subversion
  3. Spring Config.
  4. Spring Annotations
  5. Data Mining
150+ Refcardz Available · Get them all

Link Details

Previous | Next

Surprise Me!

Link 762991 thumbnail
User 744593 avatar

By jincyv
via beyondrelational.com
Published: Mar 19 2012 / 06:35

Drop default constraints of which you don't know the name
If you ever add a default constraint on a table without giving it a name, SQL Server will give it a somewhat random name which you cannot guess. To drop those constraints such a query might come in handy:
Vote up
Vote down
  • 10
  • 0
  • 516
  • 329
SaveShareSend Tags: , , ,

Add your comment


Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.

Voters For This Link (10)



Voters Against This Link (0)