Column Properties (General Page)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

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.

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 (Transact-SQL).

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, Specify Computed Columns in a Table.

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 Use Sparse Columns.

Is Column Set
Indicates whether the column is a column set. Possible values are True and False. For more information, see Use 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.

Statistical Semantics
Indicates whether statistical semantic search is enabled for the column. For more information, see Semantic Search (SQL Server).

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