I am using DMO in delphi to create Table and modify existing table in SQL database. I can not find any info about how to insert new column into an existing table but you can add column.

By having a look at Enterprise manager you can insert column without problem.

If anyone know how Enterprise manager does it, Please help. I am sure it uses DMO as well.

I also have an additional query about Collation property of Column in the table : If anyone experienced that when you change Collation property of a Column it also changes AllowNulls property to True also.{Vise versa }

Thanks,