Yes there are columns, actions and views that AppSheet will automatically generate and cannot effectively be removed.
When you define a data column as REF type, there will be a "Related xyz" column created in the referenced table. If you don't need those "Related xyz" columns, you can redefine your data column as Enum and then set the Base Type as REF. The column will still behave as a Ref column BUT the "Related xyz" columns will not be automatically generated.
When you insert a Table into the app, there will be ADD, EDIT and DELETE actions automatically included in the actions list. For REF columns, there will also be a "View Ref" action automatically created. This action will show a button on DEtail views allowing users to navigate to the row being referenced. Handy in some use cases.
Also when you add a Table, there are Form and Detail views automatically created. Ref columns will create an Inline view under the referenced table.
I recommend leaving the auto-generated items alone. You can delete them but they will get re-generated at some point in the future. There is no harm or performance impact to having them in the app with one EXCEPTION. "Related xyz" columns can add to Sync times. If they are not being used, then switch the column that generated them to an Enum/Ref type column.
Please ask if you have other specific questions.
I hope this helps!
LinkedIn
Twitter
