my project needed to drop default constarint...
I am able to acess the name of constraint by sysobjects .
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
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......