Persistent Blob

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

Table Type: Company

Table Name: Persistent Blob
Database Table Name: CRONUS UK Ltd_$Persistent Blob$63ca2fa4-4f03-4f2b-a480-172fef340d3f

Table Number: 4151

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Persistent Blob$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Blob]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Persistent Blob$63ca2fa4-4f03-4f2b-a480-172fef340d3f]

Show/hide columns in Persistent Blob table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchbigint
3Blob Searchimage
4$systemId Searchuniqueidentifier
5$systemCreatedAt Searchdatetime
6$systemCreatedBy Searchuniqueidentifier
7$systemModifiedAt Searchdatetime
8$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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