dbproperty

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

Table Type: System

Table Name: dbproperty
Database Table Name: $ndo$dbproperty

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [$ndo$dbproperty]

Show/hide an example select of all columns by name

SELECT
   [programid]
   ,[chartable]
   ,[maxrecsize]
   ,[maxloginattempts]
   ,[passwordexpindays]
   ,[supergroupid]
   ,[unifiedloginallowed]
   ,[contype]
   ,[shadowpwd]
   ,[databasemagic]
   ,[databaseversionno]
   ,[clientdatabaseversionno]
   ,[maintainviews]
   ,[diagnostics]
   ,[identifiers]
   ,[maintainrelationships]
   ,[convertidentifiers]
   ,[invalididentifierchars]
   ,[license]
   ,[checkcodepage]
   ,[quickfind]
   ,[maintaindefaults]
   ,[locktimeout]
   ,[locktimeoutperiod]
   ,[hardrowlock]
   ,[bufferedrows]
   ,[securityoption]
   ,[enabledforserver]
   ,[uidoffset]
   ,[applicationversion]
   ,[applicationfamily]
FROM
   [$ndo$dbproperty]

Show/hide columns in dbproperty table

Column IDColumn NameData Type
1programid Primary Key Searchint
2chartable Searchimage
3maxrecsize Searchint
4maxloginattempts Searchint
5passwordexpindays Searchint
6supergroupid Searchvarchar(128)
7unifiedloginallowed Searchtinyint
8contype Searchint
9shadowpwd Searchvarchar(128)
10databasemagic Searchint
11databaseversionno Searchint
12clientdatabaseversionno Searchint
13maintainviews Searchint
14diagnostics Searchint
15identifiers Searchvarchar(2000)
16maintainrelationships Searchint
17convertidentifiers Searchint
18invalididentifierchars Searchvarchar(128)
19license Searchimage
20checkcodepage Searchint
21quickfind Searchint
22maintaindefaults Searchint
23locktimeout Searchint
24locktimeoutperiod Searchint
25hardrowlock Searchint
26bufferedrows Searchint
27securityoption Searchint
28enabledforserver Searchint
29uidoffset Searchint
30applicationversion Searchvarchar(50)
31applicationfamily Searchvarchar(50)

Leave a Reply

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