Hello
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
drop default constarint
