TableMetadata
Contains the complete metadata for a Dataverse table, including column definitions, relationship metadata, and primary key/name information.
TableMetadata Class
Properties
Name | Type | Default | Description |
|---|---|---|---|
Columns | ColumnMetadataCollection | The collection of column metadata for all columns on this table. | |
IsIntersect | bool | False | Indicates whether this table is an intersect (junction) table used to support a many-to-many relationship. |
ManyToMany | List<ManyToManyMetadata> | Metadata for all many-to-many (N:N) relationships defined on this table. | |
ManyToOne | List<OneToManyMetadata> | Metadata for all many-to-one (N:1) relationships where this table is the referencing (child) table. | |
ObjectTypeCode | int | 0 | The numeric object type code assigned to this table by Dataverse. |
OneToMany | List<OneToManyMetadata> | Metadata for all one-to-many (1:N) relationships where this table is the referenced (parent) table. | |
PrimaryIdColumn | string | The logical name of the table's primary key column (e.g. 'accountid', 'contactid'). | |
PrimaryImageColumn | string | The logical name of the table's primary image column, if one is configured. | |
PrimaryNameColumn | string | The logical name of the table's primary name column (e.g. 'name', 'fullname'). This is the column displayed as the record's display name. | |
TableName | string | The logical name of the table in Dataverse (e.g. 'account', 'contact'). |
Name:
ColumnsType:
ColumnMetadataCollection
Description:
The collection of column metadata for all columns on this table.
Name:
IsIntersectType:
bool
Default:
False
Description:
Indicates whether this table is an intersect (junction) table used to support a many-to-many relationship.
Name:
ManyToManyType:
List<ManyToManyMetadata>
Description:
Metadata for all many-to-many (N:N) relationships defined on this table.
Name:
ManyToOneType:
List<OneToManyMetadata>
Description:
Metadata for all many-to-one (N:1) relationships where this table is the referencing (child) table.
Name:
ObjectTypeCodeType:
int
Default:
0
Description:
The numeric object type code assigned to this table by Dataverse.
Name:
OneToManyType:
List<OneToManyMetadata>
Description:
Metadata for all one-to-many (1:N) relationships where this table is the referenced (parent) table.
Name:
PrimaryIdColumnType:
string
Description:
The logical name of the table's primary key column (e.g. 'accountid', 'contactid').
Name:
PrimaryImageColumnType:
string
Description:
The logical name of the table's primary image column, if one is configured.
Name:
PrimaryNameColumnType:
string
Description:
The logical name of the table's primary name column (e.g. 'name', 'fullname'). This is the column displayed as the record's display name.
Name:
TableNameType:
string
Description:
The logical name of the table in Dataverse (e.g. 'account', 'contact').
OneToManyMetadata Class
Properties
Name | Type | Default | Description |
|---|---|---|---|
ReferencedTable | string | The logical name of the referenced (parent) table — the 'one' side of the relationship. | |
ReferencedTableColumn | string | The primary key column of the referenced (parent) table. | |
ReferencingTable | string | The logical name of the referencing (child) table — the 'many' side of the relationship. | |
ReferencingTableColumn | string | The lookup column on the referencing (child) table that points to the referenced (parent) table. | |
RelationshipName | string | The schema name of the relationship in Dataverse. |
Name:
ReferencedTableType:
string
Description:
The logical name of the referenced (parent) table — the 'one' side of the relationship.
Name:
ReferencedTableColumnType:
string
Description:
The primary key column of the referenced (parent) table.
Name:
ReferencingTableType:
string
Description:
The logical name of the referencing (child) table — the 'many' side of the relationship.
Name:
ReferencingTableColumnType:
string
Description:
The lookup column on the referencing (child) table that points to the referenced (parent) table.
Name:
RelationshipNameType:
string
Description:
The schema name of the relationship in Dataverse.
ManyToManyMetadata Class
Properties
Name | Type | Default | Description |
|---|---|---|---|
IntersectTableName | string | The logical name of the intersect (junction) table that links the two related tables. | |
RelationshipName | string | The schema name of the relationship in Dataverse. | |
Table1 | string | The logical name of the first table in the relationship. | |
Table1IntersectColumn | string | The column in the intersect table that references the first table's primary key. | |
Table1PrimaryKey | string | The primary key column of the first table. | |
Table2 | string | The logical name of the second table in the relationship. | |
Table2IntersectColumn | string | The column in the intersect table that references the second table's primary key. | |
Table2PrimaryKey | string | The primary key column of the second table. |
Name:
IntersectTableNameType:
string
Description:
The logical name of the intersect (junction) table that links the two related tables.
Name:
RelationshipNameType:
string
Description:
The schema name of the relationship in Dataverse.
Name:
Table1Type:
string
Description:
The logical name of the first table in the relationship.
Name:
Table1IntersectColumnType:
string
Description:
The column in the intersect table that references the first table's primary key.
Name:
Table1PrimaryKeyType:
string
Description:
The primary key column of the first table.
Name:
Table2Type:
string
Description:
The logical name of the second table in the relationship.
Name:
Table2IntersectColumnType:
string
Description:
The column in the intersect table that references the second table's primary key.
Name:
Table2PrimaryKeyType:
string
Description:
The primary key column of the second table.