Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

Column Properties (General Page)

Use this page to view properties for the selected column.

Information on this page is read-only. To modify the column, close the Column Properties dialog box, expand the table and columns in Object Explorer, right-click the column, and then click Design.

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.

NoteNote

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.