synapse cursor to check multiple tables

gistfile1.txt

DECLARE @TableName nvarchar(128);
DECLARE @Command nvarchar(500);

DECLARE TableCursor CURSOR FOR 
SELECT table_name FROM information_schema.tables
WHERE table_schema = 'myschema';

OPEN TableCursor;

FETCH NEXT FROM TableCursor INTO @TableName;

WHILE @@FETCH_STATUS = 0
BEGIN
    -- Replace this with your command. For example, to select all rows from each table:
    SET @Command = 'SELECT * FROM myschema.' + QUOTENAME(@TableName) + ';';
    EXEC sp_executesql @Command;

    FETCH NEXT FROM TableCursor INTO @TableName;
END;

CLOSE TableCursor;
DEALLOCATE TableCursor;