Object Metadata

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

Table Type: System

Table Name: Object Metadata
Database Table Name: Object Metadata

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 can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Object Metadata]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Object Type]
   ,[Object ID]
   ,[Metadata]
   ,[User Code]
   ,[User AL Code]
   ,[Metadata Version]
   ,[Hash]
   ,[Object Subtype]
   ,[Has Subscribers]
   ,[Symbol Reference]
   ,[Schema Hash]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Object Metadata]

Show/hide columns in Object Metadata table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Object Type Primary Key Searchint
3Object ID Primary Key Searchint
4Metadata Searchimage
5User Code Searchimage
6User AL Code Searchimage
7Metadata Version Searchint
8Hash Searchnvarchar(64)
9Object Subtype Searchnvarchar(60)
10Has Subscribers Searchtinyint
11Symbol Reference Searchimage
12Schema Hash Searchint
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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