T-SQL Function: Invalid object name

Question

I have read several posts with similar topic headers but I don't think my question is answered.

I created a function (say dbo.fnABC()) with: Returns Table . . . and Select Top 10 . . . and executed it.

Then I created a Query:

Select * from dbo.fnABC()

. . . and it returns the expected 10 rows.

However, in both the Function AND the Query, dbo.fnABC() has a red, squiggly underline and a quick hover shows:

Invalid object name dbo.fnABC()

It's working and all - but I would like to know why the squiggly lines under the Function name?
What will make it a valid object name?

Thanks!!

steenbergh · Accepted Answer · 2015-11-10 22:15:42Z

3

Intellisense is cached and you should refresh that cache. Disabling and re-enabling Intellisense should do that (using the button on the toolbar right next to 'New Query') or use the shortcut keys ctrl+shift+r to refresh the cache directly. The red suiggly should now disappear.

answered Nov 10, 2015 at 22:15

steenbergh

1,7913 gold badges24 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pmbAustin · Accepted Answer · 2015-11-10 22:14:52Z

2

In SSMS, try "Edit -> Intellisense -> Refresh Local Cache".

And then wait for a few seconds to see if it's now recognized.

answered Nov 10, 2015 at 22:14

pmbAustin

4,0101 gold badge27 silver badges35 bronze badges

1 Comment

Talay Over a year ago

Sorry. I'm using SQL Server 2008 R2.

Collectives™ on Stack Overflow

T-SQL Function: Invalid object name

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related