SSMS Red Squiggly Line

Often when you are working in SQL Server Management Studio (SSMS), tables, views, and other objects will get highlighted with a red squiggly line like SSMS does not know if the object exists or not in the database.

For an example, I am going to create a brand new table called Test_Asset2.

 

sq1

Now I will try an write a select statement using the new table.  As can be seen below, I get the red squiggly line and the note saying:  “Invalid Object Name”

We know that is not true because we just created the table!  The select statement will still work, but the editor does not think the table is there.

sq2

The problem is SSMS’ IntelliSense does not always refresh in a timely matter.  We can “force” it to refresh by pressing the following keys (all at the same time):   Ctrl – Shift – R

After we press the keys, the red squiggly line disappears because IntelliSense is now refreshed with all of the current objects in the database.

sq3

For a list of many, many other SSMS keyboard shortcuts, this link shows you all of them:

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts?view=sql-server-2017

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s