If I created a view constructed from a few tables in SQL Server, and used that as a Table in AppSheet, what is the behaviour of Updates, Adds and Deletes?
For example:
CREATE VIEW appsheet.table AS
SELECT
table_1.column_1,
table_1.column_2,
table_2.column_3
FROM table_1
LEFT JOIN table_2 ON table_1.[column_1] = table_2.[column_1]
UNION ALL
SELECT
table_3.column_1,
table_3.column_2,
table_3.column_3
FROM table_3
table_1 (Parent table) has column_1 as Primary Key, and table_2 (child table) has a different Primary Key (not column_1).
Questions:-
In the AppSheet UX:
- Will updates propagate through 3 tables? Say if I edited table_1.[column_1], will table_2.[column_1] be updated as well
- Will deletes DROP CASCADE through 3 tables? Say if table_1 was parent, table_2 was child, will deleting a parent record drop all child records
SQL Server Version: Microsoft SQL Server 2019
Solved! Go to Solution.
AFAIK, from Appsheet, you can't do any data changes on SQL Views that are JOINs of multiple Tables.
I actually attempted a test of a very simple JOIN scenario just a week or so ago, it throws an error when you try to sync.
AFAIK, from Appsheet, you can't do any data changes on SQL Views that are JOINs of multiple Tables.
I actually attempted a test of a very simple JOIN scenario just a week or so ago, it throws an error when you try to sync.
Thanks for the confirmation Marc
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |