private string GetColumnSql(string Table,System.Data.DataColumn column)
        {
 
            //0 Tablename
            //1 Coumnname
            //2 FieldType
            //3 Null / Not Null
            string sz_Null= column.AllowDBNull ? "NULL":"NOT NULL";
            string sz_Datatype = column.DataType.FullName;
            string sql = String.Format("ALTER TABLE {0} ALTER COLUMN {1} {2}" & _
              "{3};",Table,column.ColumnName,sz_Datatype,sz_Null);
            return sql;
        }

ALTER TABLE Personen ALTER COLUMN id System.Int64 NULL;

MfG Sascha

Video Disk Rekorder marke eigenbau

http://www.vdrportal.de