title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
---|---|---|---|---|---|---|---|---|---|---|
sys.pdw_nodes_columns (Transact-SQL) |
sys.pdw_nodes_columns (Transact-SQL) |
WilliamDAssafMSFT |
wiassaf |
03/03/2017 |
sql |
data-warehouse |
reference |
|
>=aps-pdw-2016||=azure-sqldw-latest |
[!INCLUDEapplies-to-version/asa-pdw]
Shows columns for user-defined tables and user-defined views.
Column Name | Data Type | Description | Range |
---|---|---|---|
object_id | int | ID of the object to which this column belongs. | |
name | sysname | Name of the column. Unique in object. | |
column_id | int | ID of the column. Unique in object. | |
system_type_id | tinyint | ID of the system type of the column. | |
user_type_id | int | ID of the type of the column as defined by the user. | |
max_length | smallint | Maximum length (in bytes) of the column. | Includes -1 (not valid) for unsupported column types. |
precision | tinyint | Precision of the column if numeric-based; otherwise, 0. | |
scale | tinyint | Scale of column if numeric-based; otherwise, 0. | |
collation_name | sysname | Name of the collation of the column if character-based; otherwise, NULL. | |
is_nullable | bit | 1 = Column is nullable. | |
is_ansi_padded | bit | 1 = Column uses ANSI_PADDING ON behavior if character, binary, or variant. | Always 0. |
is_rowguidcol | bit | 1 = Column is a declared ROWGUIDCOL. | Always 0. |
is_identity | bit | 1 = Column has identity values. | Always 0. |
is_computed | bit | 1 = Column is a computed column. | Always 0. |
is_filestream | bit | 1 = Column is a FILESTREAM column. | Always 0. |
is_replicated | bit | 1 = Column is replicated. | Always 0. |
is_non_sql_subscribed | bit | 1 = Column has a non-SQL subscriber. | Always 0. |
is_merge_published | bit | 1 = Column is merge-published. | Always 0. |
is_dts_replicated | bit | 1 = Column is replicated by using SSIS. | Always 0. |
is_xml_document | bit | 1 = Content is a complete XML document. | Always 0. |
xml_collection_id | int | 0 = No XML schema collection. | Always 0. |
default_object_id | int | ID of the default object; 0 = No default. | Always 0. |
rule_object_id | int | ID of the stand-alone rule bound to the column. 0 = No stand-alone rule. |
Always 0. |
is_sparse | bit | 1 = Column is a sparse column. | Always 0. |
is_column_set | bit | 1 = Column is a column set. | Always 0. |
pdw_node_id | int | Unique identifier of a [!INCLUDEssazuresynapse-md] node. | NOT NULL |
Requires CONTROL SERVER permission.
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
sys.all_columns (Transact-SQL)