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

Question

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?

Answer 1

Try this:

EXEC sys.sp_refreshsqlmodule 'dbo.YourViewName';

See the documentation here.