View does not appear in query - Sql Server

Question

I have a 2-field view that does not appear in the query window. When I add 3 more fields, it appears. What can be?.

View:

SELECT        B.TX_LOGIN, COUNT(A.CD_PROCESSO) AS TOTAL
FROM            dbo.TB_DUE_CAPA AS A INNER JOIN
                         dbo.TB_USUARIOS AS B ON A.CD_USUARIO_CRIACAO = B.CD_USUARIO
WHERE        (MONTH(A.DT_PROCESSO) = MONTH(GETDATE())) AND (YEAR(A.DT_PROCESSO) = YEAR(GETDATE()))
GROUP BY B.TX_LOGIN

View does not appear in window:

Permissions by the User:

Answer 1

Edit -> Intellisense -> Refresh Local Cache

Or the shortcut:

CTRL + SHIFT + R

Answer 2

Are you sure View already exists?

To delete the existing do:

DROP VIEW IF EXISTS Nome_da_View;

To recreate do:

CREATE VIEW Nome_da_View AS  
SELECT B.TX_LOGIN, COUNT(A.CD_PROCESSO) AS TOTAL
FROM   dbo.TB_DUE_CAPA AS A INNER JOIN
       dbo.TB_USUARIOS AS B ON A.CD_USUARIO_CRIACAO = B.CD_USUARIO
WHERE  (MONTH(A.DT_PROCESSO) = MONTH(GETDATE())) AND (YEAR(A.DT_PROCESSO) = YEAR(GETDATE()))
GROUP BY B.TX_LOGIN;

Check the permissions of views of the database objects, as it may be that you n~]when have.

Also check what @Lockzera said, because it wouldn’t surprise me if it happens to windows even...

Answer 3

There is a Bug in SQL Server when windows 10 'suspends activity'( when it is long without moving and ends up hibernating) sql server Buga, just restart the machine.