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.