dqmetadata

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

Table Type: System

Table Name: dqmetadata
Database Table Name: $ndo$dqmetadata

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [$ndo$dqmetadata]

Show/hide an example select of all columns by name

SELECT
   [uniqueid]
   ,[objectid]
   ,[name]
   ,[queryid]
   ,[ispreview]
   ,[lastModifiedTime]
   ,[revision]
   ,[xmlversion]
   ,[xml]
FROM
   [$ndo$dqmetadata]

Show/hide columns in dqmetadata table

Column IDColumn NameData Type
1uniqueid Primary Key Searchuniqueidentifier
2objectid Searchint
3name Searchnvarchar(60)
4queryid Searchbigint
5ispreview Searchtinyint
6lastModifiedTime Searchdatetime
7revision Searchnvarchar(128)
8xmlversion Searchnvarchar(200)
9xml Searchimage

Leave a Reply

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