Object Metadata Snapshot

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/0

Table Type: System

Table Name: Object Metadata Snapshot
Database Table Name: Object Metadata Snapshot

Table Number: 0

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Object Metadata Snapshot can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Object Metadata Snapshot]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Object Type]
   ,[Object ID]
   ,[Metadata]
   ,[Name]
   ,[Data Per Company]
   ,[Hash]
   ,[Base Metadata]
   ,[Base Hash]
   ,[Table Blob Version]
   ,[Schema Hash]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Object Metadata Snapshot]

Show/hide columns in Object Metadata Snapshot table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Object Type Primary Key Searchint
3Object ID Primary Key Searchint
4Metadata Searchimage
5Name Searchnvarchar(60)
6Data Per Company Searchtinyint
7Hash Searchnvarchar(200)
8Base Metadata Searchimage
9Base Hash Searchnvarchar(64)
10Table Blob Version Searchint
11Schema Hash Searchint
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *