SQLDictionary

From Axaptapedia

[edit] SQL Dictionary

The SQLDictionary Table in the Ax SQL server database is the table which describes all of the Ax tables and fields.

FieldId = 0 = table name, otherwise they are the fields for that table

TABLEID  : Table Id

FIELDID  : Field Id, when 0 it si the name of the table

ARRAY  : Is zero when FieldId is zero

NAME  : Name of the Table/Field depending on Id

SQLNAME  : Name of the Table/Field in SQL, remember when recreating the same table with a long name you will get ttttnnnn where nnnn is unique in SQL server

FIELDTYPE  : Type of field

STRSIZE  : size of string

SHADOW  :

RIGHTJUSTIFY :

NULLABLE  : Is Nullable

FLAGS  :

RECVERSION  :

RECID  :

select * from SQLDictionary
where 
tableid = 1
order by FieldId

will bring back all of the columns for the address table