Skip to content

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

Latest commit

 

History

History
66 lines (60 loc) · 3.36 KB

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

File metadata and controls

66 lines (60 loc) · 3.36 KB

title: "sys.pdw_nodes_columns (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/03/2017" ms.prod: "" ms.prod_service: "sql-data-warehouse, pdw" ms.service: "sql-data-warehouse" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" 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: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions"

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)