Thanks. This seems to be a problem. When I EXEC [art].[pCreateArtList_View] in the editor, I get a message, that the EXECUTE is denied due to my permissions.

P.S. Refresh doesn't help too.

That is exactly I wonder. I don't get any error messages. Instead of that I get "Commands completed successfully." but nothing happens.

Here is a code example

CREATE OR ALTER PROCEDURE [art].[pCreateArtList_View]

AS

EXEC ('CREATE VIEW [art].[vArtList]

AS

SELECT art.ArtList.*, loc.location.City, loc.location.Branch

FROM art.ArtList JOIN loc.location ON art.ArtList.artNo = loc.location.artNo')

---------------

EXEC ('CREATE VIEW [art].[vArtList]

AS

SELECT art.ArtList.*, loc.location.City, loc.location.Branch

FROM art.ArtList JOIN...

Thank you for your answer. I need a data collection from different tables, that a can request via an interface from my application. I suppose it could be a good...