The Edit Column page lists a set of properties for a column within a table. You may set each property when creating or altering a column. Note that a column can only be edited if no data exists in the table.
Determines whether the column is the primary key field for the selected table.
The name of the column.
The data type for the column.
The length in bytes of the data type.
Determines whether the column allows null values.
The default for this column whenever a row with a null value for this column is inserted into the table. To create a default constraint for the column, enter the default value directly as text. Note: varchar, text, and character values should be surrounded in single quotes (for example, 'my default'). Surrounding parentheses are optional.
The maximum number of digits for values of this column.
The maximum number of digits that can appear to the right of the decimal point for values of this column.
Determines whether the column is used by SQL Server as an identifier column. A table can have only one column defined as an Identity, and that column must be defined using the decimal, int, numeric, smallint, bigint, or tinyint data type.
The seed value of an identity column. This option applies only to columns whose Identity option is checked.
The increment value (that is added to the identity value of the previous row) of an identity column. This option applies only to columns whose Identity option is checked.
Determines whether the column is used by SQL Server as a ROWGUID column. You can check this value only for a column that is an identity column.
Warning: There is a potential for column data loss when updating an existing column that has been created or modified outside of the Web Data Adminstrator tool. Properties such as foreign keys and indexes are not preserved when editing an existing column.