Hi!
This wos just a sample. You're correct, but you can also provide a default value for new column or make it identity.
>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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.