I believe you want SysSchema (where ManagerName=EntitySchemaManager)  and SysSchemaProperty

Ryan

Hello Fulgen,

1) Section object can be displayed using "Schema" object when creating lookup http://prntscr.com/q0zi5q

2) Section object fields can be displayed using "Schema property" object when creating lookup http://prntscr.com/q0zii1

Best regards,

Oscar

Thanks Oscar and Ryan



I tried to execute select query on both 'SysSchema' and 'SysSchemaProperty' to check its values but 'SysSchemaProperty' does not contain the fields of my section object. Please see screenshot below

Fulgen Ninofranco,

There is no way to display columns as a lookup since this information is stored in SQL server directly and it can be displayed using:

select * from information_schema.columns where [Table_Name] = 'SysAdminUnit'

this query returns all columns that SysAdminUnit table has. You can use this query to see all columns for each object separately. List of tables can be displayed using this query:

select * from information_schema.tables

Best regards,

Oscar