>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

alter table mytable add column column_name data_type