SqlDescribe Table

Id: 65527

Label: SqlDescribe

Security key: AdminTables

Settings shown are initial values.

NoteNote

Use of this table might lead to an Elevation of Privileges attack or a Denial of Service attack. The Application Object Server authorizes each create, update, or delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception will be thrown.


NoteNote

At the time of publication, portions of this topic were intentionally left blank. For the most current information, visit Microsoft Dynamics AX Online.


Field

Description

tabId

ID: 1

Type: Integer

Extended data type: tableId Extended Data Type

Label: Table

ID for the table

fieldId

ID: 2

Type: Integer

Extended data type: fieldId Extended Data Type

Label: Field

ID for the field

array

ID: 3

Type: Integer

Label: array

name

ID: 4

Type: String Size: 40

Extended data type: identifiername Extended Data Type

Label: Name

Unique name for the ID

sqlName

ID: 5

Type: String Size: 40

Extended data type: identifiername Extended Data Type

Label: Name

Unique name for the ID

fieldType

ID: 6

Enum: Types Enumeration

Label: fieldType

strSize

ID: 7

Type: Integer

Label: strSize

shadow

ID: 8

Enum: boolean Enumeration

Label: shadow

rightJustify

ID: 9

Enum: boolean Enumeration

Label: rightJustify

nullable

ID: 10

Enum: boolean Enumeration

Label: nullable

flags

ID: 11

Type: Integer

Label: flags

numericScale

ID: 12

Type: Integer

Label: numericScale

numericPrecision

ID: 13

Type: Integer

Label: numericPrecision

Index

Fields

Field

AllowDuplicates: No

Enabled: Yes

tabId

fieldId

array

SqlName

AllowDuplicates: Yes

Enabled: Yes

tabId

sqlName

RecId

AllowDuplicates: No

Enabled: Yes

RecId

Community Additions

ADD
Show: