Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old July 19th, 2006, 08:12 AM
Registered User
Join Date: Jul 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default drop default constarint

my project needed to drop default constarint...
I am able to acess the name of constraint by sysobjects .
MY query
Alter table <table name> drop <name of default constraint reteived from sysobjects>
is working absolutely fine in SQL server 2000
But the same query is not running in a code of vb.NET.????????

my query looks like:::
alter table actdata drop DF__actdata__mytest4__2A4B4B5E

""DF__actdata__mytest4__2A4B4B5E"" is reteived from sysobjects

error which i get
while running on VB.NET is constarint cant be droped..while on SQL it runs absolutely fine......

plzz suggest

Old August 25th, 2006, 05:43 AM
Registered User
Join Date: Aug 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts

Try this...

alter table actdata drop default DF__actdata__mytest4__2A4B4B5E
Harsh Athalye
"Nothing is impossible"

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting default value in drop down. rupen Classic ASP Basics 4 July 3rd, 2014 02:00 AM
no default value for drop down nasirmunir HTML Code Clinic 3 June 10th, 2008 01:13 PM
drop down default value MunishBhatia ASP.NET 2.0 Professional 4 September 5th, 2007 10:31 AM
Setting default for select (drop-down) box Dave Brown Beginning PHP 1 August 10th, 2005 02:16 PM
select a default value in a drop-down list crmpicco HTML Code Clinic 2 January 20th, 2005 08:23 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.