You can't add a field to a SQL Server table and keep it from accepting NULLs. The reason for this is that when a new field is created the value of that field in every record is NULL. Unfortunately, SQL Server doesn't allow you to avoid this by having a default value for the field. This also means that you can't add a bit field to an existing table because bits can't be NULL.

The solution is to use SELECT INTO to copy your table to a new table with the fields you want. You then remove your original table and rename the new one. This can be a pain becaues you have to deal with all the dependencies your table is involved in and you'll have to recreate all the permissions. The best thing to do is use a tool that can handle this for you. Visual Studio comes with a database designer that can make changes like this.


>I wish to modify structures of some tables populated with data on a SQL Server. My specific question is how to change the NULL property of certain columns? My generic question is how do people modify structure on SQL Server? I miss the 'MODI STRU' of FOX.
>
>Chen