Skip to main content

Hello,

Is there an IFS data dictionary available for the source tables which tells us the data type, data definition, required fields, etc.?

When writing a query (SQL Query/Query Builder), it would be really helpful to have something to reference.

Thank you!

Hi

With this query, you can check the data types of the columns of all tables and views in the database and whether they can be empty or not.
select * from all_tab_columns a where a.table_name LIKE '%TABLE OR VIEW NAME%' AND NULLABLE='N'
-- CHECK NULLABLE CLOUMN

 

Reply


Terms & ConditionsCookie settings