hi
i want to add a new column through a vb app with this conditions :
1- it get only float numbers
2- not null
3- it has a default value = 0
4-it has no constraint
[FONT=Consolas][SIZE=2][FONT=Consolas][SIZE=2][FONT=Consolas][SIZE=2]ALTER TABLE[/SIZE][/FONT][/SIZE][/FONT][/SIZE][/FONT][SIZE=2][FONT=Consolas] NFFeeds ADD FEED4 Float not null default(0)
when i exec this command it work ok but a constraint is create under this column that i dont want this constraint be created.this constraint named : DF__NFFeeds__FEED4__778AC167 [/FONT][/SIZE]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.