sys-pdw-nodes-columns-transact-sql.md

title	sys.pdw_nodes_columns (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
ms.assetid	268c77b7-1d71-4197-a2ed-5e2b2b8fc260
caps.latest.revision	7
author	barbkess
ms.author	barbkess
manager	jhubbard

sys.pdw_nodes_columns (Transact-SQL)

[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw_md]

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 [!INCLUDEssSDW] node.	NOT NULL

Permissions

Requires CONTROL SERVER permission.

See Also

SQL Data Warehouse and Parallel Data Warehouse Catalog Views
sys.all_columns (Transact-SQL)