SQL Server Views as Data Source

AppSheet AppSheet Q&A
1

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

2

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.

3 Likes
3

Thanks for the confirmation Marc