Vlad if the table has records you cannot add the field as NOT NULL unless you provied a default value for the field.
>Hi!
>
>When you want to do this programmaticall, run command ALTER TABLE, for example, "ALTER TABLE MyTable ADD MyField int NOT NULL".
>
>When you whant to do this manually in the Enterprise Manager for SQL Server, right click on the table, select 'Design', then in the list of fields add the field you need, save.
>
>HTH.
>
>>Hi All:
>> How can I modify that table in a Sql Server if the selected table is not empty. I.E. I am trying to add an extra field to the table on Sql Server that alreday has records in it.
>>Thanks
Alexandre Palma
Senior Application Architect