I need to get all field names,label,edt used,datatype and size of datatype for any table/view? is it possible to display the relations attached in a table too!! please reply with the code/job.
You can use SysDictTable and SysDictField classes to get that information. Look at the cross references for examples in standard code.
Example - \Data Dictionary\Tables\WHSTmpFieldName\Methods\populateFieldNames
Can we get Relations defined for the table using SysDicTable and SysDictField Classes
Yes, you can use SysDictTable.relations().
I am getting fieldnames,datatypes,label and string length but relations are not coming. I am new to this . please suggest
That method return a Set and you may need to iterate through the elements in it.
Look at \Classes\DMFEntityBase\getRelationStr
Only first relation defined in the tble is coming.. how to iterate through the elements. can you have any sample code related to the above image .pls suggest
use this way u will get relations.
thanks for the code but my requirement is display of fieldnames,label,datatype,strlength and relations for the table. As MArtin Said using Sysdicttable.relations is fetching the relations but only first relation is printing. i need to iterate through the table to print relations. pls suggest