incident_sla not part of sys_db_object and sys_dictionary

[kanikag]

is there any parameter or any changes that can be made from admin end so that database view table like incident_sla can be part of sys_db_object and sys_dictionary table

[Dr Atul G- LNG]

Hi @kanikag 

What parameters you want to change? 

[Bert_c1]

Any table and field in a Database View are in sys_db_object and sys_dictionary.

[Ankur Bawiskar]

@kanikag 

"incident_sla" is database view which joins incident and sla table

It won't be available in sys_db_object as sys_db_object only holds table data

Database view is a type of table which is shown on the fly by joining the tables

If my response helped please mark it correct and close the thread so that it benefits future readers.

[kanikag]

How do we get the column info of the view created by the join, is there a way to get the metdata info like we get for tables?