public SQLColumn(SqlDataReader dr)
{
object_id = Convert.ToInt32(dr["object_id"]);
name = Convert.ToString(dr["name"]);
column_id = Convert.ToInt32(dr["column_id"]);
system_type_id = Convert.ToInt32(dr["system_type_id"]);
user_type_id = Convert.ToInt32(dr["user_type_id"]);
max_length = Convert.ToInt32(dr["max_length"]);
precision = Convert.ToInt32(dr["precision"]);
scale = Convert.ToInt32(dr["scale"]);
collation_name = Convert.ToString(dr["collation_name"]);
is_ansi_padded = Convert.ToBoolean(dr["is_ansi_padded"]);
is_rowguidcol = Convert.ToBoolean(dr["is_rowguidcol"]);
is_identity = Convert.ToBoolean(dr["is_identity"]);
is_computed = Convert.ToBoolean(dr["is_computed"]);
is_filestream = Convert.ToBoolean(dr["is_filestream"]);
is_replicated = Convert.ToBoolean(dr["is_replicated"]);
is_non_sql_subscribed = Convert.ToBoolean(dr["is_non_sql_subscribed"]);
is_merge_published = Convert.ToBoolean(dr["is_merge_published"]);
is_dts_replicated = Convert.ToBoolean(dr["is_dts_replicated"]);
is_xml_document = Convert.ToBoolean(dr["is_xml_document"]);
xml_collection_id = Convert.ToInt32(dr["xml_collection_id"]);
default_object_id = Convert.ToInt32(dr["default_object_id"]);
rule_object_id = Convert.ToInt32(dr["rule_object_id"]);
is_sparse = Convert.ToBoolean(dr["is_sparse"]);
is_column_set = Convert.ToBoolean(dr["is_column_set"]);
column_type_string = DB.GetSqlColumnType(system_type_id);
is_nullable = Convert.ToBoolean(dr["is_nullable"]);
}
