Is there any equivalent is available for 'sp_refreshview' in Azure Synapse Dedicated SQL Pool?

When i tried , it shows below error.

Since VIEWS WONT GET UPDATED AUTOMATICALLY, is there any other command or system stored procedure available in Azure Synapse Analytics's Dedicated SQL Pool other than 'ALTER VIEW' Approach?

CodePudding user response：

Try this:

EXEC sys.sp_refreshsqlmodule 'dbo.YourViewName';