Deleting a column DEFAULT value


	Deleting a column DEFAULT value

ntziolis

3-7-2008 11:51 AM

126 views

tags:

optional. separate by commas., microsoft, database, sql, sql 2005, default, constraints, tsql, mssql

ntziolis says:

Nice TSQL script to delete the default value constraint when you dont know the name.

Add a Comment

Login to Comment. Not a member yet? Sign up

Resort Plans Nude "Anything Goes" Party

Warm gruyere sandwich: recipe

Omar Khadr: The Guantánamo Files

WHICH FLAVOUR OF ICE CREAM WOULD YOU SWAP ...

SUPERSTAR iPod Music Centre

A2K = Access to Knowledge :: Intellectual ...

More clips from ntziolis

Howto use a answering file to run an unatt...

Howt install Vista and Windows Server 2008...

Integrate windows updates into an WIM Imag...

Today's Top Clips

visit the Top Clips page

View the Top Clips from March 7, 2008

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/0eb46af7-9517-4e0f-8c86-655008f4564d/4F3C908B-55E9-4EEB-8FCB-405F40F7566C/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.thescripts.com/forum/thread515152.html" href="http://www.thescripts.com/forum/thread515152.html" style="font-size: 11px;">www.thescripts.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thescripts.com/forum/thread515152.html">Deleting a column DEFAULT</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.thescripts.com/forum/thread515152.html">
DECLARE @default sysname
SELECT @default = object_name(cdefault)
FROM   syscolumns
WHERE  id = object_id('yourtable')
AND  name = 'yourcolumn'<BR /><DIV>
EXEC ('ALTER TABLE yourtable DROP CONSTRAINT ' + @default)</DIV></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/4F3C908B-55E9-4EEB-8FCB-405F40F7566C/blog/" title="blog or email this clip"><img src="http://content7.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>