Column Properties (General Page)

Options

• Name
  The name of the column.

• Data Type
  The type of data that the column can hold. If the data type is a user-defined data type, the user-defined data type is displayed. If the data type is not a user-defined data type, then the system data type is displayed. For more information, see Data Types (Database Engine).

• System Type
  The type of data that the column can hold. If the data type is a system data type, then the system data type is displayed. If the data type is a user-defined data type, the system data type that makes up the user-defined data type is displayed.

• Primary Key
  Indicates whether the column is a primary key. Possible values are Trueand False.

• Allow Nulls
  Indicates whether the column accepts null values. Possible values are True and False.

• Is Computed
  Indicates whether the column value is the result of a computed expression.

• Computed text
  Indicates the statement used to compute the column text. For more information, see Computed Columns.

• Identity
  Indicates whether the column is the identity column for the table. Possible values are True and False.

• Identity Seed
  Indicates the initial row value for an identity column.

• Identity Increment
  The Identity Increment property specifies the value Microsoft SQL Server adds to the greatest existing row identity value as it generates an identity value for a row being inserted.

• Default Binding
  The SQL Server default bound to the column. This option is blank if no default is bound.

• Default Schema
  Identifies the database schema owning the default bound to the referenced column. This option is blank if no default is bound.

• Rule
  Identifies the data integrity constraint that is bound to the column. This option is blank if no rule is bound.

• Rule Schema
  Displays the SQL Server database schema that owns the rule bound to the referenced column. This option is blank if no rule is bound.

• Length
  Indicates the maximum number of characters or bytes accepted by the column.

• Collation
  Displays the current collation for the column. If blank, the collation property is inherited from the object.

• Numeric Precision
  Indicates the maximum number of digits in a fixed-precision, numeric data type.

• Numeric Scale
  Indicates the number of digits to the right of the decimal point in a fixed-precision, numeric data type.

• XML Schema Namespace
  Defines the type of the XML column by way of XML Schema Definition (XSD) Language validation.

• XML Schema Namespace schema
  The SQL Server schema that owns the XML Schema Namespace.

  Note

  There are several common but different meanings of the word schema. SQL Server uses schema to organize database objects. It is similar to ownership. XML uses the schema to define the organization of XML information into a series of namespaces. It is a way to group related XML code together.

• Is Sparse
  Indicates whether the column is a sparse column. Possible values are True and False. For more information, see Using Sparse Columns.

• Is Column Set
  Indicates whether the column is a column set. Possible values are True and False. For more information, see Using Column Sets.

• ANSI Padding Status
  Indicates whether ANSI padding is on or off. For more information, see SET ANSI_PADDING (Transact-SQL).

• Full Text
  Displays whether the column participates in full-text queries.

• Not For Replication
  Indicates whether the column is available for replication. Possible values are True and False.

See Also

Concepts