sys.pdw_nodes_tables (Transact-SQL)

Applies to: Azure Synapse Analytics Analytics Platform System (PDW)

Contains a row for each table object that a principal either owns or on which the principal has been granted some permission.

Column Name	Data Type	Description	Range
<inherited columns>		For a list of columns that this view inherits, see sys.objects.
lob_data_space_id	int		Always 0.
filestream_data_space_id	int	Data space ID for a FILESTREAM filegroup or Information not available.	NULL
max_column_id_used	int	Maximum column ID used by this table.
lock_on_bulk_load	bit	Table is locked on bulk load.	TBD
uses_ansi_nulls	bit	Table was created with the SET ANSI_NULLS database option ON.	1
is_replicated	bit	1 = Table is published using replication.	0; replication is not supported.
has_replication_filter	bit	1 = Table has a replication filter.	0
is_merge_published	bit	1 = Table is published using merge replication.	0; not supported.
is_sync_tran_subscribed	bit	1 = Table is subscribed using an immediate updating subscription.	0; not supported.
has_unchecked_assembly_data	bit	1 = Table contains persisted data that depends on an assembly whose definition changed during the last ALTER ASSEMBLY. Will be reset to 0 after the next successful DBCC CHECKDB or DBCC CHECKTABLE.	0; no CLR support.
text_in_row_limit	int	0 = Text in row option is not set.	Always 0.
large_value_types_out_of_row	bit	1 = Large value types are stored out-of-row.	Always 0.
is_tracked_by_cdc	bit	1 = Table is enabled for change data capture	Always 0; no CDC support.
lock_escalation	tinyint	The value of the LOCK_ESCALATION option for the table: 2 = AUTO	Always 2.
lock_escalation_desc	nvarchar(60)	A text description of the lock_escalation option.	Always ꞌAUTOꞌ.
pdw_node_id	int	Unique identifier of a Azure Synapse Analytics node.	NOT NULL

See Also

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views