Class AzureSynapseAnalyticsSchema.NodesTable
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
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.
See sys.pdw_nodes_tables.
[Table(Schema = "sys", Name = "pdw_nodes_tables", IsView = true)]
public class AzureSynapseAnalyticsSchema.NodesTable- Inheritance
-
AzureSynapseAnalyticsSchema.NodesTable
- Extension Methods
Properties
CreateDate
Date the object was created.
[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }Property Value
FilestreamDataSpaceID
Data space ID for a FILESTREAM filegroup or Information not available.
Range: NULL
[Column("filestream_data_space_id")]
[NotNull]
public int FilestreamDataSpaceID { get; set; }Property Value
HasReplicationFilter
1 = Table has a replication filter.
Range: 0
[Column("has_replication_filter")]
[NotNull]
public bool HasReplicationFilter { get; set; }Property Value
HasUncheckedAssemblyData
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.
Range: 0; no CLR support.
[Column("has_unchecked_assembly_data")]
[NotNull]
public bool HasUncheckedAssemblyData { get; set; }Property Value
IsMSShipped
Object is created by an internal SQL Server component.
[Column("is_ms_shipped")]
[NotNull]
public bool IsMSShipped { get; set; }Property Value
IsMergePublished
1 = Table is published using merge replication.
Range: 0; not supported.
[Column("is_merge_published")]
[NotNull]
public bool IsMergePublished { get; set; }Property Value
IsPublished
Object is published.
[Column("is_published")]
[NotNull]
public bool IsPublished { get; set; }Property Value
IsReplicated
1 = Table is published using replication.
Range: 0; replication is not supported.
[Column("is_replicated")]
[NotNull]
public bool IsReplicated { get; set; }Property Value
IsSchemaPublished
Only the schema of the object is published.
[Column("is_schema_published")]
[NotNull]
public bool IsSchemaPublished { get; set; }Property Value
IsSyncTranSubscribed
1 = Table is subscribed using an immediate updating subscription.
Range: 0; not supported.
[Column("is_sync_tran_subscribed")]
[NotNull]
public bool IsSyncTranSubscribed { get; set; }Property Value
IsTrackedByCdc
1 = Table is enabled for change data capture
Range: Always 0; no CDC support.
[Column("is_tracked_by_cdc")]
[NotNull]
public bool IsTrackedByCdc { get; set; }Property Value
LargeValueTypesOutOfRow
1 = Large value types are stored out-of-row.
Range: Always 0.
[Column("large_value_types_out_of_row")]
[NotNull]
public bool LargeValueTypesOutOfRow { get; set; }Property Value
LobDataSpaceID
Range: Always 0.
[Column("lob_data_space_id")]
[NotNull]
public int LobDataSpaceID { get; set; }Property Value
LockEscalation
The value of the LOCK_ESCALATION option for the table: 2 = AUTO
Range: Always 2.
[Column("lock_escalation")]
[NotNull]
public byte LockEscalation { get; set; }Property Value
LockEscalationDesc
A text description of the lock_escalation option.
Range: Always ꞌAUTOꞌ.
[Column("lock_escalation_desc")]
[NotNull]
public string LockEscalationDesc { get; set; }Property Value
LockOnBulkLoad
Table is locked on bulk load.
Range: TBD
[Column("lock_on_bulk_load")]
[NotNull]
public bool LockOnBulkLoad { get; set; }Property Value
MaxColumnIDUsed
Maximum column ID used by this table.
[Column("max_column_id_used")]
[NotNull]
public int MaxColumnIDUsed { get; set; }Property Value
ModifyDate
Date the object was last modified by using an ALTER statement. If the object is a table or a view, modify_date also changes when an index on the table or view is created or altered.
[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }Property Value
Name
Object name.
[Column("name")]
[NotNull]
public string Name { get; set; }Property Value
Object
objects (sys.objects)
[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }Property Value
ObjectID
Object identification number. Is unique within a database.
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }Property Value
ParentObjectID
ID of the object to which this object belongs.
0 = Not a child object.
[Column("parent_object_id")]
[NotNull]
public int ParentObjectID { get; set; }Property Value
PdwNodeID
Unique identifier of a Azure Synapse Analytics node.
Range: NOT NULL
[Column("pdw_node_id")]
[NotNull]
public int PdwNodeID { get; set; }Property Value
PrincipalID
ID of the individual owner, if different from the schema owner. By default, schema-contained objects are owned by the schema owner. However, an alternate owner can be specified by using the ALTER AUTHORIZATION statement to change ownership.
Is NULL if there is no alternate individual owner.
Is NULL if the object type is one of the following:
C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
PK = PRIMARY KEY constraint
R = Rule (old-style, stand-alone)
TA = Assembly (CLR-integration) trigger
TR = SQL trigger
UQ = UNIQUE constraint
EC = Edge constraint
[Column("principal_id")]
[NotNull]
public int PrincipalID { get; set; }Property Value
SchemaID
ID of the schema that the object is contained in.
Schema-scoped system objects are always contained in the sys or INFORMATION_SCHEMA schemas.
[Column("schema_id")]
[NotNull]
public int SchemaID { get; set; }Property Value
TextInRowLimit
0 = Text in row option is not set.
Range: Always 0.
[Column("text_in_row_limit")]
[NotNull]
public int TextInRowLimit { get; set; }Property Value
TypeColumn
Object type:
AF = Aggregate function (CLR)
C = CHECK constraint
D = DEFAULT (constraint or stand-alone)
F = FOREIGN KEY constraint
FN = SQL scalar function
FS = Assembly (CLR) scalar-function
FT = Assembly (CLR) table-valued function
IF = SQL inline table-valued function
IT = Internal table
P = SQL Stored Procedure
PC = Assembly (CLR) stored-procedure
PG = Plan guide
PK = PRIMARY KEY constraint
R = Rule (old-style, stand-alone)
RF = Replication-filter-procedure
S = System base table
SN = Synonym
SO = Sequence object
U = Table (user-defined)
V = View
EC = Edge constraint
Applies to: SQL Server 2012 (11.x) and later.
SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = SQL table-valued-function
TR = SQL DML trigger
TT = Table type
UQ = UNIQUE constraint
X = Extended stored procedure
Applies to: SQL Server 2014 (12.x) and later, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW).
ST = STATS_TREE
Applies to: SQL Server 2016 (13.x) and later, Azure SQL Database, Azure Synapse Analytics, Analytics Platform System (PDW).
ET = External Table
[Column("type")]
[NotNull]
public string TypeColumn { get; set; }Property Value
TypeDesc
Description of the object type:
AGGREGATE_FUNCTION
CHECK_CONSTRAINT
CLR_SCALAR_FUNCTION
CLR_STORED_PROCEDURE
CLR_TABLE_VALUED_FUNCTION
CLR_TRIGGER
DEFAULT_CONSTRAINT
EXTENDED_STORED_PROCEDURE
FOREIGN_KEY_CONSTRAINT
INTERNAL_TABLE
PLAN_GUIDE
PRIMARY_KEY_CONSTRAINT
REPLICATION_FILTER_PROCEDURE
RULE
SEQUENCE_OBJECT
Applies to: SQL Server 2012 (11.x) and later.
SERVICE_QUEUE
SQL_INLINE_TABLE_VALUED_FUNCTION
SQL_SCALAR_FUNCTION
SQL_STORED_PROCEDURE
SQL_TABLE_VALUED_FUNCTION
SQL_TRIGGER
SYNONYM
SYSTEM_TABLE
TABLE_TYPE
UNIQUE_CONSTRAINT
USER_TABLE
VIEW
[Column("type_desc")]
[NotNull]
public string TypeDesc { get; set; }Property Value
UsesAnsiNulls
Table was created with the SET ANSI_NULLS database option ON.
Range: 1
[Column("uses_ansi_nulls")]
[NotNull]
public bool UsesAnsiNulls { get; set; }