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.
Primary Key
Determines whether the column is the primary key field for the selected table.
Column Name
The name of the column.
Data Type
The data type for the column.
Length
The length in bytes of the data type.
Allow Null
Determines whether the column allows null values.
Default Value
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.
Precision
The maximum number of digits for values of this column.
Scale
The maximum number of digits that can appear to the right of the decimal point for values of this column.
Identity
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.
Identity Seed
The seed value of an identity column. This option applies only to columns whose Identity option is checked.
Identity Increment
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.
Is RowGuid
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.
|
