What are the challenges you face when working across database platforms? Take the survey
Options

foreign key not recognized inside function

edited July 24, 2008 10:21AM in SQL Prompt Previous Versions
the following code:
SELECT *
FROM Document.Status S
INNER JOIN Document.StatusType ST ON
<<cursor here>>
and I can see foreign key in list candidates

but if I write the same inside function like this:
CREATE FUNCTION Func1(@Param1 int)
RETURNS TABLE
AS
RETURN
(
SELECT *
FROM Document.Status S
INNER JOIN Document.StatusType ST ON
<<cursor here>>
)
GO

intellisense do not offer me any relations between the tables

Is there a way to activate foreign key list candidates inside functions?
Sign In or Register to comment.