48 lines (43 loc) · 2.77 KB

title

sys.pdw_nodes_tables (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

473b5d14-171b-4a16-9195-acf36d3f786c

caps.latest.revision

8

author

barbkess

ms.author

barbkess

manager

jhubbard

sys.pdw_nodes_tables (Transact-SQL)

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

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

See Also

SQL Data Warehouse and Parallel Data Warehouse Catalog Views