Question Add anew column to a database table with specific conditions

[pooya1072]

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

what is the commandText ?
thanks

 

[IanRyder]

Hi,

Have a look here:-

SQL ALTER TABLE Statement

Hope that helps.

Cheers,

Ian

 

[pooya1072]

thanks ... plaese look at my command :

 [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]

 

[IanRyder]

Hi,

I do not know what you mean since you have added a Field with CONSTRAINTS of Not Null and Default so it will create something like this??

Have a read through the SQL Constraint Chapters here:-

SQL Constraints

Cheers,

Ian