sys.pdw_nodes_columns (Transact-SQL)
Applies to:
Azure Synapse Analytics
Analytics Platform System (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 Azure Synapse Analytics node. | NOT NULL |
Permissions
Requires CONTROL SERVER permission.
See Also
Azure Synapse Analytics and Parallel Data Warehouse Catalog Views
sys.all_columns (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru