My t-sql is red as if the table doesn't exist

Alen Cappelletti 891

Hi,
I have a strange behavior on a table. My code is not validated in SSMS when writing. The statement works... I tried closing the work window, reconnecting, nothing always in RED. Does anyone have any ideas?
Thanks Alen

User's image

Viorel 111.8K Reputation points

2023-03-13T17:46:57.6866667+00:00

Does it help if you press <Ctrl+Shift+R> and wait few seconds?
Alen Cappelletti 891 Reputation points

2023-03-13T22:46:08.53+00:00

YESSSSSS!! Viorel! It fixed! Thanks!
(Ctrl+Shift+R) : )
PercyTang-MSFT 12,426 Reputation points Microsoft Vendor

2023-03-14T02:47:40.1933333+00:00

Hi @Alen Cappelletti

I understand your feelings very well. Sometimes I get the same problem, and even though the query works fine, it shows a red squiggly line. This bothers me.

Glad to see your issue solved.

Best regards,

Percy Tang

1 answer

Erland Sommarskog 100.8K Reputation points MVP

2023-03-13T22:18:42.2566667+00:00

It's not SSMS that runs your queries, it's SQL Server. Just run the query, and if it works, just smile. Don't be a slave under this intlellinonsense. (I have it turned off. I just can't stand it.)
Please sign in to rate this answer.
Alen Cappelletti 891 Reputation points

2023-03-13T22:32:34.3133333+00:00

Hi Erland! You're right but I'm moving to SQL Server a long Sybase procedure... and it's very helpful when all the code rewritten are "green"... but it runs...
it's more a curiosity... on the first 1500 rewritten code line only this passage is red!

; )

ALEN
Sign in to comment