sys.pdw_nodes_columns (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

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 SQL Data Warehouse node. NOT NULL

Permissions

Requires CONTROL SERVER permission.

See Also

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